Changeset 23612

Timestamp:

Mar 30, 2009, 2:41:33 PM (17 years ago)

Author:

Paul Price

Message:

Adding exp_id. Cleaning up.

File:

• trunk/ippTools/share/warptool_definebyquery.sql (modified) (3 diffs)

trunk/ippTools/share/warptool_definebyquery.sql

@@ -1 +1 @@
 SELECT
     *
-FROM
-    (SELECT DISTINCT
+FROM (
+    SELECT DISTINCT
         fakeRun.*,
         chipRun.chip_id,
@@ -8 +8 @@
         rawExp.telescope,
         rawExp.dateobs,
+        rawExp.exp_id,
         rawExp.exp_tag,
         rawExp.exp_name,
@@ -28 +29 @@
         rawExp.sun_angle
     FROM fakeRun
-    JOIN camRun
-        using(cam_id)
-    JOIN chipRun
-        using(chip_id)
-    JOIN rawExp
-        using(exp_id)
+    JOIN camRun USING(cam_id)
+    JOIN chipRun USING(chip_id)
+    JOIN rawExp USING(exp_id)
     WHERE
-        fakeRun.state = 'full') as Foo
+        fakeRun.state = 'full') AS possibleWarps