Changeset 18942 for branches/eam_branch_20080719/ippTools/share/camtool_pendingcleanupexp.sql

Timestamp:

Aug 6, 2008, 10:24:54 AM (18 years ago)

Author:

eugene

Message:

finish coding of cleanup steps for cam, fake, warp, diff, stack

File:

• branches/eam_branch_20080719/ippTools/share/camtool_pendingcleanupexp.sql (modified) (1 diff)

branches/eam_branch_20080719/ippTools/share/camtool_pendingcleanupexp.sql

@@ -1 +1 @@
 SELECT
-    chipProcessedImfile.*,
-    chipRun.state,
-    chipRun.workdir,
-    chipRun.label,
-    chipRun.reduction,
-    chipRun.expgroup,
-    chipRun.dvodb,
-    chipRun.tess_id,
-    chipRun.end_stage
-FROM chipRun
-JOIN chipProcessedImfile
-    USING(chip_id)
+    camProcessedExp.*,
+    camRun.state,
+    camRun.workdir,
+    camRun.label,
+    camRun.reduction,
+    camRun.expgroup,
+    camRun.dvodb,
+    camRun.tess_id,
+    camRun.end_stage
+FROM camRun
+JOIN camProcessedExp
+    USING(cam_id)
 WHERE
-    chipRun.state = 'goto_cleaned'
+    camRun.state = 'goto_cleaned'