Changeset 28345 for trunk/ippTools/share/diffphottool_input.sql

Timestamp:

Jun 15, 2010, 4:00:56 PM (16 years ago)

Author:

Paul Price

Message:

Need to get camera out.

File:

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

trunk/ippTools/share/diffphottool_input.sql

@@ -1 +1 @@
 SELECT
     diffPhotRun.*,
-    diffSkyfile.path_base
+    diffSkyfile.path_base,
+    rawExp.camera
 FROM diffPhotRun
 JOIN diffRun USING(diff_id)
 JOIN diffSkyfile USING(diff_id)
+JOIN diffInputSkyfile USING(diff_id, skycell_id)
+JOIN warpRun ON warp1 = warp_id -- only JOINing on input warps!
+JOIN fakeRun USING(fake_id)
+JOIN camRun USING(cam_id)
+JOIN chipRun USING(chip_id)
+JOIN rawExp USING(exp_id)