Changeset 20903 for branches/bills_081204/ippTools/share/magictool_definebyquery_temp_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_temp_insert.sql (modified) (1 diff)

branches/bills_081204/ippTools/share/magictool_definebyquery_temp_insert.sql

@@ -14 +14 @@
 JOIN warpSkyfile USING(warp_id, skycell_id)
 JOIN diffInputSkyfile
-    ON diffInputSkyfile.warp_id = warpSkyfile.warp_id
+    ON diffInputSkyfile.warp1 = warpSkyfile.warp_id
     AND diffInputSkyfile.skycell_id = warpSkyfile.skycell_id
-    AND diffInputSkyfile.template = 0 -- selecting inputs only
 JOIN diffRun USING(diff_id)
 JOIN diffSkyfile USING(diff_id)