root/inputs/VegBank/observation__community/create.sql @ 11627
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 |