Changeset 27682

Timestamp:

Apr 14, 2010, 1:37:32 PM (16 years ago)

Author:

Paul Price

Message:

Fix query.

File:

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

trunk/ippTools/share/stacktool_inputskyfile.sql

@@ -5 +5 @@
 JOIN stackInputSkyfile USING(stack_id)
 JOIN warpRun USING(warp_id)
-JOIN warpSkyfile USING(warp_id, tess_id, skycell_id)
+JOIN warpSkyfile
+    ON warpSkyfile.warp_id = warpRun.warp_id
+    AND warpSkyfile.tess_id = stackRun.tess_id
+    AND warpSkyfile.skycell_id = stackRun.skycell_id
 JOIN fakeRun USING(fake_id)
 JOIN camRun USING(cam_id)