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

Timestamp:

Jul 5, 2007, 3:16:08 PM (19 years ago)

Author:

jhoblitt

Message:

rename exp_id -> exp_name
rename exp_tag -> exp_id
add add rawExp.exp_tag for use as an external name only

File:

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

trunk/ippTools/share/regtool_pendingimfile.sql

@@ -1 @@
-SELECT
-   newImfile.*,
-   newExp.workdir
-FROM newImfile
-LEFT JOIN newExp
-    USING(exp_tag)
-LEFT JOIN rawExp
-    USING(exp_tag)
-WHERE
-    newExp.exp_tag is NOT NULL
-    AND rawExp.exp_tag IS NULL
+SELECT DISTINCT * FROM
+    (SELECT
+        newExp.exp_id,
+        newExp.tmp_exp_name,
+        newExp.tmp_camera,
+        newExp.tmp_telescope,
+        newExp.workdir,
+        newImfile.tmp_class_id,
+        newImfile.uri
+    FROM newImfile
+    JOIN newExp
+        USING(exp_id)
+    LEFT JOIN rawImfile
+        ON newExp.exp_id = rawImfile.exp_id
+        AND newImfile.tmp_class_id = rawImfile.tmp_class_id
+    WHERE
+        newExp.state = 'run'
+        AND rawImfile.tmp_class_id IS NULL) as Foo