root/inputs/CTFS/StemObservation/create.sql @ 7125
1 |
SELECT * |
---|---|
2 |
FROM "StemObservation.src" |
3 |
LEFT JOIN "Stem.src" USING ("TreeID", "StemID") |
4 |
LEFT JOIN "Organism.src" USING ("TreeID") |
5 |
LEFT JOIN "InfraspecificEpithet.src" USING ("SpeciesID", "SubSpeciesID") |
6 |
LEFT JOIN "SpecificEpithet.src" USING ("SpeciesID") |
7 |
LEFT JOIN "Genus.src" USING ("GenusID") |
8 |
LEFT JOIN "Family.src" USING ("FamilyID") |