Changes between Version 7 and Version 8 of Model Results

Timestamp:

Jan 3, 2012 2:00:36 PM (13 years ago)

Author:

celine

Comment:

--

Model Results

@@ -37 +37 @@
         sub6.res_value as ers,
         sub7.res_value as riverareakm2,
-        sub8.res_value as abondance
+        sub8.res_value as abondance,
+        sub9.res_value as ers2
           from
         (select id_drain,dmer,dsource,res_value as md, the_geom from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
@@ -69 +70 @@
         res_mod_id=8) as sub8
         on sub1.id_drain=sub8.id_drain
+join 
+        (select id_drain, res_value from rht.rht_topology join rht.resultmodel on res_id_drain=id_drain where 
+        res_mod_id=9) as sub9
+        on sub1.id_drain=sub9.id_drain
 );