Changes between Version 10 and Version 11 of Lakes


Ignore:
Timestamp:
Oct 19, 2010 3:05:58 PM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Lakes

    v10 v11  
    1313 
    1414{{{ 
    15 select r.wso_id, r.wso1_id, cont_pixel, upstream_a, l.wso_id from ccm21.riversegments as r inner join ccm21.lakes as l on r.cont_pixel=l.upstream_a and r.wso_id=l.wso_id where r.wso_id=291112 order by cont_pixel 
     15select r.wso_id, r.wso1_id, l.gid, cont_pixel, upstream_a, l.wso_id from ccm21.riversegments as r inner join ccm21.lakes as l on (r.cont_pixel, r.wso_id, r.pfafstette)= (l.upstream_a, l.wso_id, l.pfafstette) where r.wso_id=291112 order by l.gid 
    1616}}} 
     17or 
    1718{{{ 
    1819select r.wso_id, r.wso1_id, l.gid, cont_pixel, upstream_a, l.wso_id from ccm21.riversegments as r inner join ccm21.lakes as l on r.cont_pixel=l.upstream_a and r.wso_id=l.wso_id and r.pfafstette=l.pfafstette where r.wso_id=291112 order by l.gid