Changeset 20903 for branches/bills_081204/ippTools/share/magictool_definebyquery_insert.sql

Timestamp:

Dec 4, 2008, 1:44:33 PM (17 years ago)

Author:

bills

Message:

on branch. Reorganizing the diff stage to consist of a collection of
skyfiles

File:

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

branches/bills_081204/ippTools/share/magictool_definebyquery_insert.sql

@@ -3 +3 @@
 SELECT
     @MAGIC_ID@, -- Update this with the appropriate magic_id
-    diff_id,
     skycell_id
-FROM magicBestDiffs
+FROM diffSkyfile
 WHERE
-    exp_id = @EXP_ID@ -- Update this with the appropriate exp_id
+    diff_id = @DIFF_ID@ -- Update this with the appropriate diff_id
+    AND fault = 0