root/inputs/VegBank/observation__community/create.sql @ 11223
| 1 | 11160 | aaronmk | SELECT DISTINCT ON (commclass_id, comminterpretation.commname) |
|---|---|---|---|
| 2 | /* there are 330 more comminterpretations than commclasses. some of these
|
||
| 3 | multiple determinations have the same commname. */
|
||
| 4 | *
|
||
| 5 | FROM commclass |
||
| 6 | LEFT JOIN comminterpretation USING (commclass_id) |
||
| 7 | ORDER BY commclass_id, comminterpretation.commname, comminterpretation_id |