SELECT *
FROM "StemObservation.src"
LEFT JOIN "Stem.src" USING ("*TreeID", "authorStemCode")
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")