root/trunk/inputs/CTFS/StemObservation/create.sql @ 14053
| 1 |
SELECT * |
|---|---|
| 2 |
FROM "StemObservation.src" |
| 3 |
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") |