Changes between Version 2 and Version 3 of Problems with dams
- Timestamp:
- Feb 18, 2011 5:54:12 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Problems with dams
v2 v3 4 4 select r.wso1_id, r.gid, g.gid, cs_nbdams, r.nbdams, fra_note, fra_esp_id from ccm21.riversegments r 5 5 inner 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 6 inner join geobs2010.franchissabilite_piscicole f on g.ref_id=f.fra_ref_id where r.cs_nbdams>35 7 order by fra_esp_id, cs_nbdams 7 8 }}}