SELECT *
FROM "StemObservation.src"
LEFT JOIN "Stem.src" USING ("TreeID", "StemID")
LEFT JOIN "Organism.src" USING ("TreeID")
LEFT JOIN "InfraspecificEpithet.src" USING ("SpeciesID", "SubSpeciesID")
LEFT JOIN "SpecificEpithet.src" USING ("SpeciesID")
LEFT JOIN "Genus.src" USING ("GenusID")
LEFT JOIN "Family.src" USING ("FamilyID")