Changeset 19107 for trunk/ippTools/share/stacktool_definebyquery_insert.sql

Timestamp:

Aug 17, 2008, 2:57:39 PM (18 years ago)

Author:

eugene

Message:

drop the join against tess_id, add explicit table refs to tess_id and skycell_id

File:

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

trunk/ippTools/share/stacktool_definebyquery_insert.sql

@@ -7 +7 @@
 FROM warpSkyfile
 JOIN warpRun
-    USING(warp_id, tess_id)
+    USING(warp_id)
 JOIN fakeRun
-    USING(fake_id, tess_id)
+    USING(fake_id)
 JOIN camRun
-    USING(cam_id, tess_id)
+    USING(cam_id)
 JOIN chipRun
-    USING(chip_id, tess_id)
+    USING(chip_id)
 JOIN rawExp
-    USING(exp_id, tess_id)
+    USING(exp_id)
 WHERE
-    skycell_id = '%s'
-    AND tess_id = '%s'
+    warpSkyfile.skycell_id = '%s'
+    AND warpRun.tess_id = '%s'
     AND rawExp.filter = '%s'
     AND warpSkyfile.fault = 0