Revision 11277
Added by Aaron Marcuse-Kubitza about 11 years ago
| create.sql | ||
|---|---|---|
| 1 | 1 |
SELECT * |
| 2 | 2 |
FROM "taxonObservation" |
| 3 | 3 |
LEFT JOIN "taxonInterpretation" USING ("TAXONOBSERVATION_ID")
|
| 4 |
LEFT JOIN party collector ON collector."PARTY_ID" = "taxonInterpretation"."collector_ID" |
|
| 5 | 4 |
LEFT JOIN "plantConcept_" USING ("PLANTCONCEPT_ID")
|
| 6 | 5 |
; |
Also available in: Unified diff
inputs/CVS/taxonObservation_/map.csv: collector_ID: remapped it to UNUSED and removed the join to party via it, like in VegBank