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

Timestamp:

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

Author:

jhoblitt

Message:

remove stale use of chipProcessedExp

File:

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

trunk/ippTools/share/camtool_find_processedexp.sql

@@ -1 @@
-SELECT
+SELECT DISTINCT
     camProcessedExp.*,
     rawExp.exp_tag,
@@ -7 +7 @@
     rawExp.filelevel
 FROM camProcessedExp
-JOIN chipProcessedExp
+JOIN chipRun
+    USING(chip_id)
+JOIN chipProcessedImfile
     USING(chip_id)
 JOIN rawExp
-    ON chipProcessedExp.exp_id = rawExp.exp_id
+    ON chipProcessedImfile.exp_id = rawExp.exp_id
 WHERE -- bogus condition so there is a pre-existing where to append to
     camProcessedExp.cam_id IS NOT NULL