Changeset 20964 for branches/bills_081204/ippTools/share/magictool_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_inputs.sql (modified) (1 diff)

branches/bills_081204/ippTools/share/magictool_inputs.sql

@@ -10 +10 @@
     diffSkyfile.path_base,
     diffSkyfile.fault
-FROM magicInputSkyfile
-JOIN magicRun USING(magic_id)
+FROM magicRun
+JOIN magicInputSkyfile
+USING(magic_id)
 JOIN diffSkyfile
-    USING(diff_id)
+    ON magicInputSkyfile.diff_id = diffSkyfile.diff_id
+    AND magicInputSkyfile.node = diffSkyfile.skycell_id
 UNION
 -- Merged skycells