back to first page..

select r.wso1_id, r.gid, g.gid, cs_nbdams, r.nbdams, fra_note, fra_esp_id from ccm21.riversegments r 
inner join geobs2010.roe_ccm_500_final g on g.gid=r.gid 
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