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