Index: trunk/ippTools/share/camtool_find_processedexp.sql
===================================================================
--- trunk/ippTools/share/camtool_find_processedexp.sql	(revision 14027)
+++ trunk/ippTools/share/camtool_find_processedexp.sql	(revision 14031)
@@ -1,3 +1,3 @@
-SELECT
+SELECT DISTINCT
     camProcessedExp.*,
     rawExp.exp_tag,
@@ -7,8 +7,10 @@
     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