Changes between Version 35 and Version 36 of CookBook join Temperature_CCM


Ignore:
Timestamp:
May 21, 2010 11:00:12 AM (15 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • CookBook join Temperature_CCM

    v35 v36  
    2525-- to extract only the min distance you need a join 
    2626 
    27 select * from( 
     27select t.gid, t.winter, t.summer from( 
    2828select min(distance),gid,pk from temperature.tmp_ccm 
    2929group by distance, gid,pk) as sub1