Changeset 17713 for trunk/ippTools/share/difftool_todiffskyfile.sql

Timestamp:

May 16, 2008, 10:14:03 AM (18 years ago)

Author:

Paul Price

Message:

Need camera.

File:

• trunk/ippTools/share/difftool_todiffskyfile.sql (modified) (3 diffs)

trunk/ippTools/share/difftool_todiffskyfile.sql

@@ -3 +3 @@
     diffRun.workdir,
     diffRun.skycell_id,
-    diffRun.tess_id
+    diffRun.tess_id,
+    rawExp.camera
 FROM diffRun
 JOIN diffInputSkyfile
@@ -11 +12 @@
     AND diffInputSkyfile.skycell_id = warpSkyfile.skycell_id
     AND diffInputSkyfile.tess_id    = warpSkyfile.tess_id
+JOIN warpRun
+    ON warpRun.warp_id = warpSkyfile.warp_id
+JOIN camRun
+    USING(cam_id)
+JOIN chipRun
+    USING(chip_id)
+JOIN rawExp
+    USING(exp_id)
 LEFT JOIN diffSkyfile
     ON diffInputSkyfile.diff_id = diffSkyfile.diff_id
@@ -16 +25 @@
   diffRun.state = 'run'
   AND diffSkyfile.diff_id IS NULL
-