Changeset 38937 for trunk/ippTools/share/addtool_find_ffsummary_id.sql

Timestamp:

Oct 21, 2015, 5:44:52 PM (11 years ago)

Author:

watersc1

Message:

Untested fullforce_summary handlers. addtool compiles and addstar_run.pl doesn't complain about variables, but I have not confirmed they work correctly.

File:

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

trunk/ippTools/share/addtool_find_ffsummary_id.sql

@@ -1 @@
-SELECT
-     fullForceRun.*
-FROM 
-     fullForceRun
-JOIN fullForceSummary using (ff_id)
-
-LEFT JOIN (SELECT ff_id       AS added_ff_id,
-                  addRun.dvodb AS previous_dvodb
-           FROM addRun
-JOIN fullForceRun on (ff_id = stage_id and addRun.stage = 'fullforce_summary')
-          ) as foo
-     ON ff_id = added_ff_id 
-     --AND stage = 'skycal'
+SELECT fullForceRun.* FROM fullForceRun
+JOIN fullForceSummary USING (ff_id)
+LEFT JOIN (
+     SELECT ff_id AS added_ff_id,
+            addRun.dvodb AS previous_dvodb
+     FROM addRun
+     JOIN fullForceRun ON (ff_id = stage_id and addRun.stage = 'fullforce_summary')
+     ) as foo
+ON ff_id = added_ff_id 
+     -- AND stage = 'skycal'
      -- hook for qualifying the join on the previous_dvodb
      AND %s