Changeset 9929

Timestamp:

Nov 9, 2006, 11:28:18 AM (20 years ago)

Author:

jhoblitt

Message:

add camera to the output of dettool -raw

File:

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

trunk/ippTools/src/dettool.c

@@ -921 +921 @@
 
     psString query = psStringCopy(
-            "SELECT detInputExp.det_id, detRun.det_type, rawImfile.*"
+            "SELECT"
+            "   detInputExp.det_id,"
+            "   detRun.det_type,"
+            "   rawImfile.*,"
+            "   rawDetrendExp.camera"
             " FROM rawImfile"
-            " JOIN detInputExp USING(exp_tag) "
-            " JOIN detRun ON detInputExp.det_id = detRun.det_id"
-            " WHERE detRun.state = 'run'"
+            " JOIN detInputExp"
+            "   USING(exp_tag) "
+            " JOIN rawDetrendExp"
+            "   USING(exp_tag) "
+            " JOIN detRun"
+            "   ON detInputExp.det_id = detRun.det_id"
+            " WHERE"
+            "   detRun.state = 'run'"
         );