Changeset 12228

Timestamp:

Mar 5, 2007, 12:02:35 PM (19 years ago)

Author:

jhoblitt

Message:

nest query instead a subquery to make adding search criteria easier upstream
add additional information to the output

File:

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

trunk/ippTools/share/camtool_find_pendingimfile.sql

@@ -1 @@
-SELECT
-    camPendingExp.cam_id,
-    chipProcessedImfile.*,
-    rawExp.exp_tag,
-    rawExp.exp_id,
-    rawExp.camera,
-    rawExp.telescope,
-    rawExp.workdir
-FROM camPendingExp
-JOIN chipProcessedExp
-    USING(chip_id)
-JOIN chipProcessedImfile
-    USING(chip_id)
-JOIN rawExp
-    ON chipProcessedExp.exp_tag = rawExp.exp_tag
-LEFT JOIN camProcessedExp
-    ON camPendingExp.cam_id = camProcessedExp.cam_id
-LEFT JOIN camMask
-    ON camPendingExp.label = camMask.label
-WHERE
-    camProcessedExp.cam_id IS NULL
-    AND camMask.label IS NULL
+SELECT * FROM 
+     -- the subselect is so where criteria can be specified without knowing
+     -- which table the field came from
+    (SELECT
+        camPendingExp.*,
+        chipProcessedExp.*,
+        chipProcessedImfile.class_id,
+        chipProcessedImfile.uri,
+        chipProcessedImfile.bg,
+        chipProcessedImfile.bg_stdev,
+        chipProcessedImfile.bg_mean_stdev,
+        chipProcessedImfile.path_base,
+        rawExp.exp_id,
+        rawExp.camera,
+        rawExp.telescope
+    FROM camPendingExp
+    JOIN chipProcessedExp
+        USING(chip_id)
+    JOIN chipProcessedImfile
+        USING(chip_id)
+    JOIN rawExp
+        ON chipProcessedExp.exp_tag = rawExp.exp_tag
+    LEFT JOIN camProcessedExp
+        ON camPendingExp.cam_id = camProcessedExp.cam_id
+    LEFT JOIN camMask
+        ON camPendingExp.label = camMask.label
+    WHERE
+        camProcessedExp.cam_id IS NULL
+        AND camMask.label IS NULL) as foo