Changes between Version 13 and Version 14 of PATE Anguille

Timestamp:

Feb 2, 2012 10:12:25 AM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -46 +46 @@
 create table rht.rhtvs2_roe_pate_bv11axes as (
 select  b.*, t.dmer, module, module_icinf, module_icsup, minqmx, minqmxicinf, minqmxicsup, cumnbbar, etatnom from rht.roe_pate_bv11axes b     
-        join roe_v2.pre_ice_v2 r on r.id_roe=b.id_roe
-        join rht.rhtvs2 t on t.id_drain=b.id_drain
-        join rht.attributs_rht_fev_2011_vs2 a on b.id_drain=a.id_drain);
+        left join roe_v2.pre_ice_v2 r on r.id_roe=b.id_roe
+        left join rht.rhtvs2 t on t.id_drain=b.id_drain
+        left join rht.attributs_rht_fev_2011_vs2 a on b.id_drain=a.id_drain);
 
+select count(*) from rht.rhtvs2_roe_pate_bv11axes ---398
+select count(*) from rht.rhtvs2_roe_pate_bv11axes where a_conserver='TRUE' ---376
+
+drop table if exists rht.pate;
 alter table rht.rhtvs2_roe_pate_bv11axes rename to rht.pate;
 COMMENT ON TABLE rht.pate IS 'Table pate comes from roe_pate_bv11axes.xls'