Changeset 31603 for trunk/ippTools/share/regtool_pendingimfile.sql

Timestamp:

Jun 6, 2011, 12:52:49 PM (15 years ago)

Author:

watersc1

Message:

registration summitExp.dateobs/rawExp.dateobs bugfix

File:

• trunk/ippTools/share/regtool_pendingimfile.sql (modified) (1 diff)

trunk/ippTools/share/regtool_pendingimfile.sql

@@ -8 +8 @@
     newImfile.uri,
     newImfile.bytes,
-    newImfile.md5sum
+    newImfile.md5sum,
+    summitExp.dateobs AS summit_dateobs
 FROM newImfile
 JOIN newExp
     USING(exp_id)
+JOIN summitExp USING(summit_id)
 LEFT JOIN rawImfile
     ON newExp.exp_id = rawImfile.exp_id