Changes between Version 13 and Version 14 of Lakes


Ignore:
Timestamp:
May 25, 2012 1:55:19 PM (13 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Lakes

    v13 v14  
    2929 
    3030{{{ 
     31#!sql 
    3132select 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 
    3233}}} 
    3334or 
    3435{{{ 
     36#!sql 
    3537select 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 
    3638}}}