root/inputs/CVS/taxonObservation_/create.sql @ 8542
| 1 |
SELECT * |
|---|---|
| 2 |
FROM "taxonObservation" |
| 3 |
LEFT JOIN "taxonInterpretation" USING ("TAXONOBSERVATION_ID") |
| 4 |
LEFT JOIN party collector ON collector."PARTY_ID" = "taxonInterpretation"."collector_ID" |
| 5 |
LEFT JOIN "plantConcept_" USING ("PLANTCONCEPT_ID") |
| 6 |
;
|