Index: trunk/ippMonitor/def/detProcessedImfile.d
===================================================================
--- trunk/ippMonitor/def/detProcessedImfile.d	(revision 13692)
+++ trunk/ippMonitor/def/detProcessedImfile.d	(revision 14044)
@@ -1,17 +1,19 @@
-TABLE detProcessedImfile
+TABLE detProcessedImfile, rawExp
 TITLE detProcessedImfile
 FILE  detProcessedImfile.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,   stdev
-FIELD bg_mean_stdev, 8,   [stdev]
-# FIELD recipe,     10,   recipe
-# FIELD uri, 	    20,   uri
-# 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 detProcessedImfile.det_id,        7,   Det ID
+FIELD detProcessedImfile.exp_id,        5,   Exp ID
+FIELD rawExp.exp_name,                  5,   Exp Name
+FIELD detProcessedImfile.class_id,      8,   Chip ID
+FIELD detProcessedImfile.bg, 	        8,   backgnd
+FIELD detProcessedImfile.bg_stdev,      8,   stdev
+FIELD detProcessedImfile.bg_mean_stdev, 8,   [stdev]
+FIELD detProcessedImfile.path_base,     5,   path_base
 
 TAIL PHP insert_image ('PPIMAGE.JPEG1');