Revision 4369
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/CTFS/TaxonOccurrence/create.sql | ||
|---|---|---|
| 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")
|
|
Also available in: Unified diff
inputs/CTFS/: Added TaxonOccurrence/ and its joined tables