Changes between Version 2 and Version 3 of Model Results Spain

Timestamp:

Mar 16, 2012 4:36:08 PM (13 years ago)

Author:

celine

Comment:

--

Model Results Spain

@@ -28 +28 @@
 );
 
-drop table if exists rht.resultmodelBasque;
+drop table if exists ccm21.resultmodelBasque;
 create table ccm21.resultmodelBasque as (
 select sub1.*,
         sub2.res_value as mpa
           from
-        (select wso1_id,dmer,dsource,res_value as mpa, the_geom from ccm21.riversegments join ccm21.resultmodel on res_wso1_id=wso1_id where 
+        (select wso1_id,dmer as dsea,dsource,res_value as mpa, the_geom from ccm21.riversegments join ccm21.resultmodel on res_wso1_id=wso1_id where 
         res_mod_id=12) as sub1
 join