Changeset 19258 for trunk/ippTools/share/magictool_definebyquery_temp_insert.sql

Timestamp:

Aug 27, 2008, 5:57:36 PM (18 years ago)

Author:

eugene

Message:

do not join against tess_id

File:

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

trunk/ippTools/share/magictool_definebyquery_temp_insert.sql

@@ -7 +7 @@
     MAX(diffSkyfile.diff_id) AS diff_id
 FROM rawExp
-JOIN chipRun USING(exp_id, tess_id)
-JOIN camRun USING(chip_id, tess_id)
-JOIN fakeRun USING(cam_id, tess_id)
-JOIN warpRun USING(fake_id, tess_id)
-JOIN warpSkyCellMap USING(warp_id, tess_id)
-JOIN warpSkyfile USING(warp_id, skycell_id, tess_id)
+JOIN chipRun USING(exp_id)
+JOIN camRun USING(chip_id)
+JOIN fakeRun USING(cam_id)
+JOIN warpRun USING(fake_id)
+JOIN warpSkyCellMap USING(warp_id)
+JOIN warpSkyfile USING(warp_id, skycell_id)
 JOIN diffInputSkyfile
     ON diffInputSkyfile.warp_id = warpSkyfile.warp_id
     AND diffInputSkyfile.skycell_id = warpSkyfile.skycell_id
-    AND diffInputSkyfile.tess_id = warpSkyfile.tess_id
     AND diffInputSkyfile.template = 0 -- selecting inputs only
 JOIN diffSkyfile USING(diff_id)