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")