SELECT * FROM taxonobservation LEFT JOIN taxoninterpretation USING (taxonobservation_id) LEFT JOIN plantconcept_ USING (plantconcept_id) ; ALTER TABLE :table DROP COLUMN row_num;