Index: /trunk/ippTools/share/warptool_imfile.sql
===================================================================
--- /trunk/ippTools/share/warptool_imfile.sql	(revision 14028)
+++ /trunk/ippTools/share/warptool_imfile.sql	(revision 14029)
@@ -9,10 +9,10 @@
 JOIN camProcessedExp
     ON warpInputExp.cam_id = camProcessedExp.cam_id
-JOIN chipProcessedExp
-    ON camProcessedExp.chip_id = chipProcessedExp.chip_id
+JOIN chipRun
+    ON camProcessedExp.chip_id = chipRun.chip_id
 JOIN chipProcessedImfile
     ON camProcessedExp.chip_id = chipProcessedImfile.chip_id
 JOIN rawImfile -- is there any reason not to refer back to rawimfiles?
-    ON chipProcessedExp.exp_id = rawImfile.exp_id
+    ON chipProcessedImfile.exp_id = rawImfile.exp_id
 WHERE
     warpRun.state = 'run'
Index: /trunk/ippTools/share/warptool_tooverlap.sql
===================================================================
--- /trunk/ippTools/share/warptool_tooverlap.sql	(revision 14028)
+++ /trunk/ippTools/share/warptool_tooverlap.sql	(revision 14029)
@@ -9,8 +9,10 @@
 JOIN camProcessedExp
     ON warpInputExp.cam_id = camProcessedExp.cam_id
-JOIN chipProcessedExp
-    ON camProcessedExp.chip_id = chipProcessedExp.chip_id
+JOIN chipRun
+    ON camProcessedExp.chip_id = chipRun.chip_id
+JOIN chipProcessedImfile
+    ON chipRun.chip_id = chipProcessedImfile.chip_id
 JOIN rawExp
-    ON chipProcessedExp.exp_id = rawExp.exp_id
+    ON chipProcessedImfile.exp_id = rawExp.exp_id
 LEFT JOIN warpSkyCellMap
     ON warpInputExp.warp_id = warpSkyCellMap.warp_id
Index: /trunk/ippTools/share/warptool_towarped.sql
===================================================================
--- /trunk/ippTools/share/warptool_towarped.sql	(revision 14028)
+++ /trunk/ippTools/share/warptool_towarped.sql	(revision 14029)
@@ -11,8 +11,10 @@
 JOIN camProcessedExp
     ON warpSkyCellMap.cam_id = camProcessedExp.cam_id
-JOIN chipProcessedExp
-    ON camProcessedExp.chip_id = chipProcessedExp.chip_id
+JOIN chipRun
+    ON camProcessedExp.chip_id = chipRun.chip_id
+JOIN chipProcessedImfile
+    ON chipRun.chip_id = chipProcessedImfile.chip_id
 JOIN rawExp
-    ON chipProcessedExp.exp_id = rawExp.exp_id
+    ON chipProcessedImfile.exp_id = rawExp.exp_id
 LEFT JOIN warpSkyfile
     ON warpRun.warp_id = warpSkyfile.warp_id
