Changes between Version 3 and Version 4 of Joining dams ROE on CCM


Ignore:
Timestamp:
Mar 15, 2011 5:19:13 PM (14 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Joining dams ROE on CCM

    v3 v4  
    2424{{{ 
    2525select * from geobs2010.roe_ccm_500_final where gid='298703' 
    26 select r.*, o.ref_sta_id from geobs2010.roe_ccm_500_final r inner join geobs2010.obstacle_referentiel o on o.ref_id=r.ref_id where gid='293773' 
     26select o.ref_id_national, r.*, o.ref_sta_id from geobs2010.roe_ccm_500_final r inner join geobs2010.obstacle_referentiel o on o.ref_id=r.ref_id where gid='298703' 
    2727}}}