Project

General

Profile

Download (142 Bytes) Statistics
| Revision:

root/trunk/inputs/CVS/observation_/create.sql @ 12004

1 
SELECT DISTINCT ON ("OBSERVATION_ID") *
2 
FROM observation
3 
LEFT JOIN "soilObs" USING ("OBSERVATION_ID")
4 
ORDER BY "OBSERVATION_ID", "SOILOBS_ID"
(4-4/11)