Project

General

Profile

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")
(4-4/10)