Changeset 15821 for trunk/ippTools/share/pztool_pendingimfile.sql

Timestamp:

Dec 13, 2007, 4:16:36 PM (18 years ago)

Author:

jhoblitt

Message:

* empty log message *

File:

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

trunk/ippTools/share/pztool_pendingimfile.sql

@@ -1 @@
-SELECT
-    summitImfile.*,
-    summitExp.dateobs
-FROM pzPendingImfile
-JOIN summitImfile
-    USING(exp_name, camera, telescope, class, class_id)
-JOIN summitExp
-    USING(exp_name, camera, telescope)
-ORDER BY
-    summitExp.dateobs
+SELECT *
+FROM (
+    SELECT
+        summitImfile.*,
+        summitExp.dateobs
+    FROM pzPendingImfile
+    JOIN summitImfile
+        USING(exp_name, camera, telescope, class, class_id)
+    JOIN summitExp
+        USING(exp_name, camera, telescope)
+    ORDER BY
+        summitExp.dateobs
+) as Foo