Revision 11819
Added by Aaron Marcuse-Kubitza about 11 years ago
| create.sql | ||
|---|---|---|
| 1 | 1 |
SELECT DISTINCT ON ("COMMCLASS_ID", "commInterpretation".commname) *
|
| 2 | 2 |
FROM "commClass" |
| 3 | 3 |
LEFT JOIN "commInterpretation" USING ("COMMCLASS_ID")
|
| 4 |
LEFT JOIN "commConcept" USING ("COMMCONCEPT_ID")
|
|
| 4 | 5 |
ORDER BY "COMMCLASS_ID", "commInterpretation".commname, "COMMINTERPRETATION_ID" |
Also available in: Unified diff
fix: inputs/CVS/observation_community/create.sql: communityName: populate from commConcept.commName instead, because commInterpretation.commname is not always populated. this requires left-joining to commConcept.