root/inputs/VegBank/observation_/create.sql @ 11758
| 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 |