Index: /branches/eam_branch_20080918/ippTools/share/dettool_toresidimfile.sql
===================================================================
--- /branches/eam_branch_20080918/ippTools/share/dettool_toresidimfile.sql	(revision 19609)
+++ /branches/eam_branch_20080918/ippTools/share/dettool_toresidimfile.sql	(revision 19610)
@@ -55,7 +55,8 @@
     detRun.workdir,
     detRun.reduction,
-    rawImfile.exp_id,
-    rawImfile.class_id,
-    rawImfile.uri,
+    -- XXX convert these to detProcessedImfile matching this detRun 
+    detProcessedImfile.exp_id,
+    detProcessedImfile.class_id,
+    detProcessedImfile.uri,
     detNormalizedImfile.uri AS det_uri,
     detRun.ref_det_id,
@@ -74,6 +75,8 @@
 JOIN rawExp
     ON detInputExp.exp_id = rawExp.exp_id
-JOIN rawImfile
-    ON detInputExp.exp_id = rawImfile.exp_id
+JOIN detProcessedImfile
+    ON detProcessedImfile.exp_id = detInputExp.exp_id
+   AND detProcessedImfile.det_id = detRun.det_id
+   AND detProcessedImfile.iteration = detRun.iteration
 LEFT JOIN detResidImfile
     ON detRun.det_id = detResidImfile.det_id