Changeset 30997 for trunk/ippTools/share/regtool_checkstatus.sql

Timestamp:

Mar 21, 2011, 3:26:01 PM (15 years ago)

Author:

watersc1

Message:

rawExp isn't populated, join to newExp

File:

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

trunk/ippTools/share/regtool_checkstatus.sql

@@ -25 +25 @@
         LEFT JOIN newImfile ON (summitImfile.class_id = newImfile.tmp_class_id AND newExp.exp_id = newImfile.exp_id)
         LEFT JOIN rawExp ON rawExp.exp_id = newExp.exp_id
-        LEFT JOIN rawImfile ON (rawImfile.exp_id = rawExp.exp_id AND rawImfile.tmp_class_id = newImfile.tmp_class_id)
+        LEFT JOIN rawImfile ON (rawImfile.exp_id = newExp.exp_id AND rawImfile.tmp_class_id = newImfile.tmp_class_id)
         WHERE
          summitImfile.class_id = '@CLASS_ID@'