SELECT *
FROM observation
LEFT JOIN "soilObs" USING ("OBSERVATION_ID")