Index: trunk/ippMonitor/def/detResidImfile.d
===================================================================
--- trunk/ippMonitor/def/detResidImfile.d	(revision 13692)
+++ trunk/ippMonitor/def/detResidImfile.d	(revision 14044)
@@ -1,18 +1,20 @@
-TABLE detResidImfile
+TABLE detResidImfile, rawExp
 TITLE detResidImfile
 FILE  detResidImfile.php
 MENU  ipp.imfiles.dat
 
-#     field        size   name        show  link to     extras
-FIELD det_id,        7,   Det ID
-FIELD exp_tag,      15,   Exposure
-FIELD class_id,      8,   Chip ID
-FIELD bg,            8,   backgnd
-FIELD bg_stdev,      8,   bg stdev
-FIELD bg_mean_stdev, 8,   [stdev]
-FIELD iteration,     5,   iter
-# FIELD uri,        20,   uri
-# FIELD recipe,     20,   recipe
-FIELD path_base,  20,   path_base
+# the following WHERE clauses are added to all queries joined by AND
+WHERE detResidExp.exp_id = rawExp.exp_id
+
+#     field                         size   name        show  link to     extras
+FIELD detResidImfile.det_id,        7,   Det ID
+FIELD detResidImfile.exp_id,        5,   Exp ID
+FIELD rawExp.exp_name,              5,   Exp Name
+FIELD detResidImfile.class_id,      8,   Chip ID
+FIELD detResidImfile.bg,            8,   backgnd
+FIELD detResidImfile.bg_stdev,      8,   bg stdev
+FIELD detResidImfile.bg_mean_stdev, 8,   [stdev]
+FIELD detResidImfile.iteration,     5,   iter
+FIELD detResidImfile.path_base,     5,   path_base
 
 TAIL PHP insert_image ('PPIMAGE.JPEG1');