Changeset 20964 for branches/bills_081204/ippTools/share/magictool_toprocess_inputs.sql

Timestamp:

Dec 11, 2008, 5:22:00 PM (18 years ago)

Author:

bills

Message:

changes to adapt the magic to the re-worked difference stage

File:

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

branches/bills_081204/ippTools/share/magictool_toprocess_inputs.sql

@@ -11 +11 @@
 JOIN magicRun USING(magic_id)
 JOIN magicInputSkyfile USING(magic_id, node)
-JOIN diffSkyfile USING(diff_id)
+JOIN diffSkyfile 
+    ON magicRun.diff_id = diffSkyfile.diff_id
+    AND magicInputSkyfile.node = diffSkyfile.skycell_id
 JOIN rawExp USING(exp_id)
 LEFT JOIN magicNodeResult