Changes between Version 23 and Version 24 of CookBook join ROE_RHT

Timestamp:

Oct 25, 2011 4:59:06 PM (14 years ago)

Author:

celine

Comment:

--

CookBook join ROE_RHT

@@ -132 +132 @@
 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_bdcarthage bdc on bdc.id_bdcarth=cast(geo.idtrcart as integer); ---49399 lines
+join rht.rht_bdcarthage2 bdc on bdc.id_bdcarth=cast(geo.idtrcart as integer); ---49399 lines
 CREATE INDEX indexrhtbdcroe
 ON rht.rht_bdcarthage_roev2