Revision 11718
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/CVS/observation_/create.sql | ||
|---|---|---|
| 1 |
SELECT * |
|
| 1 |
SELECT DISTINCT ON ("OBSERVATION_ID") *
|
|
| 2 | 2 |
FROM observation |
| 3 | 3 |
LEFT JOIN "soilObs" USING ("OBSERVATION_ID")
|
| 4 |
ORDER BY "OBSERVATION_ID", "SOILOBS_ID" |
|
Also available in: Unified diff
bugfix: inputs/CVS/observation_/create.sql: only include one soilObs for each observation (using DISTINCT ON), rather than just left-joining them