SELECT * FROM "taxonObservation" LEFT JOIN "taxonInterpretation" USING ("TAXONOBSERVATION_ID") LEFT JOIN "plantConcept_" USING ("PLANTCONCEPT_ID") ;