Changes between Version 35 and Version 36 of model building

Timestamp:

May 21, 2010 10:05:58 PM (15 years ago)

Author:

cedric

Comment:

--

model building

@@ -51 +51 @@
 name,
 area_cd
- from ccm21.riversegments r
-left join ccm21.catchments c on r.wso1_id=c.wso1_id
-left join ccm21.seaoutlets s on s.wso_id=r.wso_id
-where r.wso_id in (select wso_id from france.wso where area='France')
+FROM ccm21.riversegments r
+LEFT JOIN ccm21.catchments c ON r.wso1_id=c.wso1_id
+LEFT JOIN ccm21.seaoutlets s ON s.wso_id=r.wso_id
+WHERE r.wso_id in (SELECT wso_id FROM france.wso WHERE area='France')
 }}}