Changeset 18923 for branches/eam_branch_20080719/ippTools/share/magictool_toprocess_inputs.sql

Timestamp:

Aug 5, 2008, 2:07:07 PM (18 years ago)

Author:

eugene

Message:

updates from HEAD

File:

• branches/eam_branch_20080719/ippTools/share/magictool_toprocess_inputs.sql (modified) (1 diff)

branches/eam_branch_20080719/ippTools/share/magictool_toprocess_inputs.sql

@@ -1 +1 @@
 SELECT
     magicTree.*,
+    rawExp.camera,
+    diffSkyfile.path_base,
     -- convert magic_id into a boolean value (1 or 0)
     -- note that the type stays a 64 bit int
     magicNodeResult.magic_id IS TRUE as done
 FROM magicTree
-JOIN magicRun
-    USING(magic_id)
-JOIN magicInputSkyfile
-    USING(magic_id, node)
-JOIN diffSkyfile
-    using(diff_id)
+JOIN magicRun USING(magic_id)
+JOIN magicInputSkyfile USING(magic_id, node)
+JOIN diffSkyfile USING(diff_id)
+JOIN rawExp USING(exp_id)
 LEFT JOIN magicNodeResult
     ON magicTree.magic_id = magicNodeResult.magic_id