Changeset 34975

Show
Ignore:
Timestamp:
01/18/2013 11:13:56 AM (6 years ago)
Author:
bills
Message:

in -skycalresult join with skycell

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • trunk/ippTools/share/staticskytool_skycalresult.sql

    r32962 r34975  
    22    skycalResult.*, 
    33    skycalRun.stack_id, 
    4     stackRun.tess_id, 
    5     stackRun.skycell_id, 
    64    stackRun.filter, 
    75    skycalRun.state, 
    86    skycalRun.label, 
    97    skycalRun.data_group, 
    10     skycalRun.sky_id 
     8    skycalRun.sky_id, 
     9    skycell.* 
    1110FROM skycalRun 
    1211JOIN skycalResult USING(skycal_id) 
    13 JOIN stackRun USING(stack_id) 
    14  
     12JOIN stackRun USING(stack_id)  
     13JOIN skycell USING(tess_id, skycell_id)