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