Changes between Version 32 and Version 33 of CookBook join ROE_RHT

Timestamp:

Jan 2, 2012 11:41:32 AM (13 years ago)

Author:

celine

Comment:

--

CookBook join ROE_RHT

@@ -130 +130 @@
 drop table if exists rht.rht_bdcarthage_roev2;
 create table rht.rht_bdcarthage_roev2 as
-select geo.*, bdc.*, roe.the_geom, roe.nom, roe.typecd, roe.typenom, roe.stypecd, roe.stypenom, roe.stanom, roe.etatcd, roe.source from roe_v2.roe_geo_v2 as geo
+select geo.*, bdc.*, roe.the_geom, roe.nom, roe.typecd, roe.typenom, roe.stypecd, roe.stypenom, roe.stanom, roe.etatcd, roe.source 
+from roe_v2.roe_geo_v2 as geo
 join  roe_v2.roe_v2 as roe on roe.id_roe=geo.id_roe
 join rht.rht_bdcarthage2 bdc on bdc.id_bdcarth=cast(geo.idtrcart as integer); ---49212 lines