Changes between Version 2 and Version 3 of Problems with dams


Ignore:
Timestamp:
Feb 18, 2011 5:54:12 PM (14 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Problems with dams

    v2 v3  
    44select r.wso1_id, r.gid, g.gid, cs_nbdams, r.nbdams, fra_note, fra_esp_id from ccm21.riversegments r  
    55inner join geobs2010.roe_ccm_500_final g on g.gid=r.gid  
    6 inner join geobs2010.franchissabilite_piscicole f on g.ref_id=f.fra_ref_id where r.cs_nbdams>35 order by fra_esp_id, cs_nbdams 
     6inner join geobs2010.franchissabilite_piscicole f on g.ref_id=f.fra_ref_id where r.cs_nbdams>35  
     7order by fra_esp_id, cs_nbdams 
    78}}}