Changeset 12419 for trunk/ippTools/share/stacktool_inputskyfile.sql

Timestamp:

Mar 12, 2007, 3:41:55 PM (19 years ago)

Author:

Paul Price

Message:

Adding series of JOINs to get rawExp.camera, following the thread from warp->cam->chip->raw.

File:

• trunk/ippTools/share/stacktool_inputskyfile.sql (modified) (2 diffs)

trunk/ippTools/share/stacktool_inputskyfile.sql

@@ -1 @@
-SELECT
+ SELECT
     warpSkyfile.*,
     rawExp.camera
@@ -11 +11 @@
 JOIN warpInputExp
     ON stackInputSkyfile.warp_id = warpInputExp.warp_id
+JOIN camProcessedExp
+    ON warpInputExp.cam_id = camProcessedExp.cam_id
+JOIN chipProcessedExp
+    ON camProcessedExp.chip_id = chipProcessedExp.chip_id
 JOIN rawExp
-    ON warpInputExp.exp_tag = rawExp.exp_tag
+    ON chipProcessedExp.exp_tag = rawExp.exp_tag
 WHERE
     stackRun.state = 'run'