root/inputs/CVS/observation_community/create.sql @ 11953
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" |