Changeset 9404

Timestamp:

Oct 7, 2006, 5:13:28 PM (20 years ago)

Author:

jhoblitt

Message:

fix idiotic use of .position instead of .det_id

File:

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

trunk/ippTools/src/detselect.c

@@ -72 +72 @@
         "SELECT"
         "   detNormalizedImfile.det_id,"
-        "   detNormalizedImfile.iteration,"
-        "   detNormalizedImfile.class_id"
+        "   detNormalizedImfile.iteration"
         " FROM detRun"
         " JOIN detInputExp"
@@ -80 +79 @@
         "   ON detRun.position = detInputExp.det_id"
         " JOIN detNormalizedImfile"
-        "   ON detInputExp.position = detNormalizedImfile.det_id"
+        "   ON detInputExp.det_id = detNormalizedImfile.det_id"
         "   AND detInputExp.iteration = detNormalizedImfile.iteration"
         " JOIN rawDetrendExp"
         "   ON detInputExp.exp_tag = rawDetrendExp.exp_tag"
         " JOIN detRunSummary"
-        "   ON detInputExp.position = detRunSummary.det_id"
+        "   ON detInputExp.det_id = detRunSummary.det_id"
         "   AND detInputExp.iteration = detRunSummary.iteration"
         " WHERE"