root/inputs/VegBank/observation_/create.sql @ 10792
1 |
SELECT DISTINCT ON (observation_id) * |
---|---|
2 |
FROM observation |
3 |
LEFT JOIN soilobs USING (observation_id) |
4 |
ORDER BY observation_id, soilobs_id |
1 |
SELECT DISTINCT ON (observation_id) * |
---|---|
2 |
FROM observation |
3 |
LEFT JOIN soilobs USING (observation_id) |
4 |
ORDER BY observation_id, soilobs_id |