Index: trunk/ippTools/share/chiptool_dropprocessedimfile_update.sql
===================================================================
--- trunk/ippTools/share/chiptool_dropprocessedimfile_update.sql	(revision 33533)
+++ trunk/ippTools/share/chiptool_dropprocessedimfile_update.sql	(revision 33617)
@@ -1,5 +1,5 @@
-UPDATE chipProcessedImfile 
-    SET quality = %d,
-        data_state = 'full',
-        magicked = 0,
-        fault = 0
+UPDATE chipProcessedImfile LEFT JOIN camRun USING(chip_id)
+    SET chipProcessedImfile.quality = %d,
+        chipProcessedImfile.data_state = 'full',
+        chipProcessedImfile.magicked = 0,
+        chipProcessedImfile.fault = 0