Changeset 19105 for trunk/ippTools/share/stacktool_definebyquery_part1.sql

Timestamp:

Aug 17, 2008, 2:50:56 PM (18 years ago)

Author:

eugene

Message:

remove tess_id from JOIN

File:

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

trunk/ippTools/share/stacktool_definebyquery_part1.sql

@@ -13 +13 @@
     SELECT
         skycell_id,
-        tess_id,
-        filter,
+        warpSkyfile.tess_id,
+        rawExp.filter,
         COUNT(warpSkyfile.skycell_id) AS num_warp -- number of warps that can be stacked
     FROM warpRun
-        JOIN warpSkyfile USING(warp_id, tess_id)
-        JOIN fakeRun USING(fake_id, tess_id)
-        JOIN camRun USING(cam_id, tess_id)
-        JOIN chipRun USING(chip_id, tess_id)
-        JOIN rawExp USING(exp_id, tess_id)
+        JOIN warpSkyfile USING(warp_id)
+        JOIN fakeRun USING(fake_id)
+        JOIN camRun USING(cam_id)
+        JOIN chipRun USING(chip_id)
+        JOIN rawExp USING(exp_id)
     WHERE
         warpRun.state = 'full'