Changes between Version 78 and Version 79 of CLC Join

Timestamp:

Jun 4, 2010 4:16:10 PM (15 years ago)

Author:

cedric

Comment:

--

CLC Join

@@ -927 +927 @@
 
   [[Image(source:data/Docs/trac/clc/clipped.png,600px)]] [[BR]]
-
+{{{
+CREATE TABLE clc.remaining_catchment AS(        
+        SELECT * FROM ccm21.catchments where gid in(
+        SELECT gid FROM ccm21.catchments c WHERE c.wso_id IN (SELECT wso_id FROM france.wso WHERE area='France')
+        except (select gid from  clc.clipped))
+        
+);
+}}}