Changeset 27276

Timestamp:

Mar 12, 2010, 12:53:26 PM (16 years ago)

Author:

Paul Price

Message:

Need to join diffRun to get diffRun.state.

File:

• trunk/ippTools/share/magictool_toprocess_inputs.sql (modified) (1 diff)

trunk/ippTools/share/magictool_toprocess_inputs.sql

@@ -15 +15 @@
     ON diffSkyfile.diff_id = magicRun.diff_id
     AND diffSkyfile.skycell_id = magicInputSkyfile.node
+JOIN diffRun
+    ON diffRun.diff_id =  diffSkyfile.diff_id
 LEFT JOIN magicNodeResult USING(magic_id, node)
 WHERE