Index: trunk/ippTools/src/detselect.c
===================================================================
--- trunk/ippTools/src/detselect.c	(revision 9431)
+++ trunk/ippTools/src/detselect.c	(revision 9440)
@@ -102,19 +102,20 @@
         // "   detRunSummary.accept,"
         // "   rawDetrendExp.camera"
-	"  FROM detRun"
-	"  JOIN detRunSummary "
-	"    ON detRun.det_id = detRunSummary.det_id"
-	"  JOIN detInputExp"
-	"    ON detRunSummary.det_id = detInputExp.det_id"
-	"   AND detRunSummary.iteration = detInputExp.iteration"
-	"  JOIN rawImfile"
-	"    ON detInputExp.exp_tag = rawImfile.exp_tag"
-	"  JOIN rawDetrendExp"
-	"    ON detInputExp.exp_tag = rawDetrendExp.exp_tag"
-	" WHERE detRun.state = 'stop'"
-	"   AND detRunSummary.accept = 1"
-	// XXX the following entry is needed to exclude db mismatched
-	// XXX these are caused by an error upstream and should be fixed
-        "   AND detRun.det_type = rawDetrendExp.object"
+        " FROM detRun"
+        " JOIN detRunSummary "
+        "   USING(det_id)"
+        " JOIN detInputExp"
+        "   ON detRunSummary.det_id = detInputExp.det_id"
+        "   AND detRunSummary.iteration = detInputExp.iteration"
+        " JOIN rawDetrendExp"
+        "   ON detInputExp.exp_tag = rawDetrendExp.exp_tag"
+        " JOIN rawImfile"
+        "   ON rawDetrendExp.exp_tag = rawImfile.exp_tag"
+        " WHERE"
+        "   detRun.state = 'stop'"
+        "   AND detRunSummary.accept = 1"
+        // XXX the following entry is needed to exclude db mismatched
+        // XXX these are caused by an error upstream and should be fixed
+//        "   AND detRun.det_type = rawDetrendExp.object"
     );
 # endif
@@ -186,5 +187,5 @@
         " FROM detNormalizedImfile"
         " JOIN detRun"
-        "   ON detNormalizedImfile.det_id = detRun.det_id"
+        "   USING(det_id)"
         " JOIN detRunSummary"
         "   ON detNormalizedImfile.det_id = detRunSummary.det_id"