Changeset 9211

Timestamp:

Oct 4, 2006, 11:16:40 AM (20 years ago)

Author:

jhoblitt

Message:

add detRun.det_type rawDetrendExp.camera, detStackedImfile.uri to the output of -tonormalize

File:

• trunk/ippTools/src/dettool.c (modified) (1 diff)

trunk/ippTools/src/dettool.c

@@ -2311 +2311 @@
     psString query = psStringCopy(
         "SELECT"
+        "   detRun.det_type,"
+        "   rawDetrendExp.camera,"
+        "   detStackedImfile.uri,"
         "   detNormalizedStatImfile.*"
         " FROM detNormalizedStatImfile"
+        " JOIN detStackedImfile"
+        "   USING(det_id, iteration, class_id)"
+        " JOIN detRun"
+        "   ON detNormalizedStatImfile.det_id = detRun.position"
+        " JOIN detInputExp"
+        "   ON detRun.position = detInputExp.det_id"
+        "   AND detRun.iteration = detInputExp.iteration"
+        " JOIN rawDetrendExp"
+        "   ON detInputExp.exp_tag = rawDetrendExp.exp_tag"
         " LEFT JOIN detNormalizedImfile"
-        "   USING(det_id, iteration, class_id)"
+        "   ON detRun.position = detNormalizedImfile.det_id"
+        "   AND detRun.iteration = detNormalizedImfile.iteration"
+        "   AND detNormalizedStatImfile.class_id = detNormalizedImfile.class_id"
         " WHERE"
         "   detNormalizedImfile.det_id IS NULL"