root/trunk/inputs/CTFS/TaxonOccurrence/create.sql @ 13357
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") |