root/inputs/CTFS/TaxonOccurrence/create.sql @ 7777
| 1 |
SELECT * |
|---|---|
| 2 |
FROM "TaxonOccurrence.src" |
| 3 |
LEFT JOIN "InfraspecificEpithet.src" USING ("SpeciesID", "SubSpeciesID") |
| 4 |
LEFT JOIN "SpecificEpithet.src" USING ("SpeciesID") |
| 5 |
LEFT JOIN "Genus.src" USING ("GenusID") |
| 6 |
LEFT JOIN "Family.src" USING ("FamilyID") |