Changeset 14031 for trunk/ippTools/share/difftool_inputskyfile.sql

Timestamp:

Jul 5, 2007, 4:08:25 PM (19 years ago)

Author:

jhoblitt

Message:

remove stale use of chipProcessedExp

File:

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

trunk/ippTools/share/difftool_inputskyfile.sql

@@ -1 @@
-SELECT
+SELECT DISTINCT
     warpSkyfile.*,
     diffInputSkyfile.template,
@@ -14 +14 @@
 JOIN camProcessedExp
     ON warpInputExp.cam_id = camProcessedExp.cam_id
-JOIN chipProcessedExp
-    ON camProcessedExp.chip_id = chipProcessedExp.chip_id
+JOIN chipRun
+    ON camProcessedExp.chip_id = chipRun.chip_id
+JOIN chipProcessedImfile
+    ON chipRun.chip_id = chipProcessedImfile.chip_id
 JOIN rawExp
-    ON chipProcessedExp.exp_id = rawExp.exp_id
+    ON chipProcessedImfile.exp_id = rawExp.exp_id
 WHERE
     diffRun.state = 'run'