Changes between Version 27 and Version 28 of CookBook join ROE_RHT

Timestamp:

Nov 2, 2011 11:50:20 AM (13 years ago)

Author:

celine

Comment:

--

CookBook join ROE_RHT

@@ -210 +210 @@
 
 ---Clause group by par id_bdcarthage
-select id_drain, count(nb_dams) as nb_dams2 from rht.rht_bdcarthage_roev2 group by id_bdcarth, id_drain;
-
-}}}
+select id_drain, count(nb_dams) as nb_dams2 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;
+}}}