Changeset 24185 for trunk/ippTools/share/magicdstool_completed_runs.sql

Timestamp:

May 14, 2009, 3:30:50 PM (17 years ago)

Author:

bills

Message:

adapt to changes in the diff and magic tables

File:

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

trunk/ippTools/share/magicdstool_completed_runs.sql

@@ -66 +66 @@
     JOIN magicInputSkyfile USING(magic_id)
     JOIN diffSkyfile
-        ON magicInputSkyfile.diff_id = diffSkyfile.diff_id
+        ON magicRun.diff_id = diffSkyfile.diff_id
         AND magicInputSkyfile.node = diffSkyfile.skycell_id
     LEFT JOIN magicDSFile