Changeset 9440 for trunk/ippTools/src/detselect.c

Timestamp:

Oct 9, 2006, 3:37:23 PM (20 years ago)

Author:

jhoblitt

Message:

more SQL fiddling

File:

• trunk/ippTools/src/detselect.c (modified) (2 diffs)

trunk/ippTools/src/detselect.c

@@ -102 +102 @@
         // "   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 +187 @@
         " FROM detNormalizedImfile"
         " JOIN detRun"
-        "   ON detNormalizedImfile.det_id = detRun.det_id"
+        "   USING(det_id)"
         " JOIN detRunSummary"
         "   ON detNormalizedImfile.det_id = detRunSummary.det_id"