root/inputs/CVS/observation_community/create.sql @ 11819
| 1 | 11814 | aaronmk | SELECT DISTINCT ON ("COMMCLASS_ID", "commInterpretation".commname) * |
|---|---|---|---|
| 2 | FROM "commClass" |
||
| 3 | LEFT JOIN "commInterpretation" USING ("COMMCLASS_ID") |
||
| 4 | 11819 | aaronmk | LEFT JOIN "commConcept" USING ("COMMCONCEPT_ID") |
| 5 | 11814 | aaronmk | ORDER BY "COMMCLASS_ID", "commInterpretation".commname, "COMMINTERPRETATION_ID" |