Changeset 10944 for trunk/ippTools/src/camtool.c

Timestamp:

Jan 5, 2007, 1:56:34 PM (19 years ago)

Author:

jhoblitt

Message:

add rawScienceExp.camera to -pendingexp & -pendingimfile

File:

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

trunk/ippTools/src/camtool.c

@@ -78 +78 @@
 
     psString query = psStringCopy(
-            "SELECT p3PendingExp.*"
+            "SELECT"
+            "   p3PendingExp.*,"
+            "   rawScienceExp.camera"
             " FROM p3PendingExp"
+            " JOIN rawScienceExp"
+            "   USING(exp_tag)"
             " LEFT JOIN p3ProcessedExp"
             "   USING(exp_tag)"
@@ -141 +145 @@
 
     psString query = psStringCopy(
-            "SELECT p2ProcessedImfile.*"
+            "SELECT"
+            "   p2ProcessedImfile.*,"
+            "   rawScienceExp.camera"   
             " FROM p3PendingExp"
+            " JOIN rawScienceExp"
+            "   USING(exp_tag)"
             " JOIN p2ProcessedImfile"
             "   USING(exp_tag, p2_version)"