root/trunk/inputs/CTFS/StemObservation/create.sql @ 12642
| 1 | 4350 | aaronmk | SELECT * |
|---|---|---|---|
| 2 | FROM "StemObservation.src" |
||
| 3 | 11865 | aaronmk | LEFT JOIN "Stem.src" USING ("*TreeID", "authorStemCode") |
| 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") |