Index: trunk/ippTools/share/camtool_find_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/camtool_find_pendingimfile.sql	(revision 12259)
+++ trunk/ippTools/share/camtool_find_pendingimfile.sql	(revision 14023)
@@ -4,5 +4,5 @@
     (SELECT
         camPendingExp.*,
-        chipProcessedExp.exp_tag,
+        chipProcessedExp.exp_id,
         chipProcessedExp.guide_id,
         chipProcessedImfile.class_id,
@@ -12,5 +12,5 @@
         chipProcessedImfile.bg_mean_stdev,
         chipProcessedImfile.path_base,
-        rawExp.exp_id,
+        rawExp.exp_name,
         rawExp.camera,
         rawExp.telescope,
@@ -22,5 +22,5 @@
         USING(chip_id)
     JOIN rawExp
-        ON chipProcessedExp.exp_tag = rawExp.exp_tag
+        ON chipProcessedExp.exp_id = rawExp.exp_id
     LEFT JOIN camProcessedExp
         ON camPendingExp.cam_id = camProcessedExp.cam_id