Index: trunk/ippTools/share/chiptool_processedimfile.sql
===================================================================
--- trunk/ippTools/share/chiptool_processedimfile.sql	(revision 18948)
+++ trunk/ippTools/share/chiptool_processedimfile.sql	(revision 21308)
@@ -1,3 +1,5 @@
 SELECT DISTINCT
+    chipProcessedImfile.chip_id,
+    chipImfile.chip_imfile_id,
     chipProcessedImfile.class_id,
     chipProcessedImfile.uri,
@@ -14,10 +16,8 @@
     rawExp.filelevel
 FROM chipRun
+JOIN chipImfile
+    USING(chip_id)
 JOIN chipProcessedImfile
     USING(chip_id)
 JOIN rawExp
     ON chipProcessedImfile.exp_id = rawExp.exp_id
-WHERE
--- bogus test; just here so there there is a 'WHERE' stmt to append conditionals too
-    chipProcessedImfile.exp_id is NOT NULL
-