SELECT *
FROM "TaxonOccurrence.src"
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")