root/inputs/CTFS/StemObservation/create.sql @ 9286
1 | 4350 | aaronmk | 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") |