Project

General

Profile

Download (248 Bytes) Statistics
| Revision:

root/trunk/inputs/CTFS/TaxonOccurrence/create.sql @ 13744

1 4369 aaronmk 
SELECT *
2 
FROM "TaxonOccurrence.src"
3 11865 aaronmk 
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")