Changes between Version 28 and Version 29 of CookBook join ROE_RHT

Timestamp:

Nov 2, 2011 3:50:51 PM (13 years ago)

Author:

celine

Comment:

--

CookBook join ROE_RHT

@@ -206 +206 @@
 join rht.rht_topology as topo on bdc.id_drain=topo.id_drain; ---49212 lines
 
-alter table rht.rht_bdcarthage_roev2 add column nb_dams integer;
-update rht.rht_bdcarthage_roev2 set nb_dams=1;
+alter table rht.rht_bdcarthage_roev2 add column nbdams integer;
+update rht.rht_bdcarthage_roev2 set nbdams=1;
 
 ---Clause group by par id_bdcarthage
-select id_drain, count(nb_dams) as nb_dams2 from rht.rht_bdcarthage_roev2 group by id_drain;
+select id_drain, count(nbdams) as nbdams from rht.rht_bdcarthage_roev2 group by id_drain;
 
 drop table if exists rht.rht_bdcarthage_roev2_nbdams;
 create table rht.rht_bdcarthage_roev2_nbdams as
-select id_drain, count(nb_dams) as nb_dams from rht.rht_bdcarthage_roev2 as r group by id_drain;
-}}}
+select id_drain, count(nbdams) as nbdams from rht.rht_bdcarthage_roev2 as r group by id_drain;
+}}}