Changeset 34041 for branches/meh_branches/ppstack_test/ippTools/share/pztool_pendingimfile.sql

Timestamp:

Jun 19, 2012, 5:24:19 PM (14 years ago)

Author:

mhuber

Message:

merging latest r34040 trunk changes to branch

Location:

branches/meh_branches/ppstack_test

Files:

• . (modified) (1 prop)
• ippTools/share/pztool_pendingimfile.sql (modified) (3 diffs)

branches/meh_branches/ppstack_test/ippTools/share/pztool_pendingimfile.sql

@@ -1 +1 @@
 SELECT *
 FROM (
-    SELECT
+    SELECT * FROM 
+    (SELECT
         summitImfile.*,
         summitExp.dateobs
@@ -20 +21 @@
         AND pzDownloadImfile.class_id IS NULL
         AND summitImfile.exp_name NOT LIKE '%a'
+    ORDER BY dateobs) AS partA
 UNION
-    SELECT
+    SELECT * FROM 
+    (SELECT
         summitImfile.*,
         summitExp.dateobs
@@ -40 +43 @@
         AND pzDownloadImfile.class_id IS NULL
         AND summitImfile.exp_name LIKE '%a'
+    ORDER BY dateobs) AS partB
 ) as Foo