SELECT *
FROM observation
LEFT JOIN soilobs USING (observation_id)