Changeset 36411 for branches/bills_branches/bills_201312/ippTools/share/fftool_todo.sql

Timestamp:

Dec 24, 2013, 1:28:47 PM (13 years ago)

Author:

bills

Message:

more changes due to the reworked tables

File:

• branches/bills_branches/bills_201312/ippTools/share/fftool_todo.sql (modified) (2 diffs)

branches/bills_branches/bills_201312/ippTools/share/fftool_todo.sql

@@ -1 +1 @@
 SELECT
     fullForceRun.*,
+    fullForceInput.warp_id,
     stackRun.tess_id,
     stackRun.skycell_id,
@@ -16 +17 @@
     JOIN chipRun USING(chip_id)
     JOIN rawExp USING(exp_id)
-    LEFT JOIN fullForceResult USING(ff_id)
+    LEFT JOIN fullForceResult USING(ff_id, warp_id)
 WHERE fullForceRun.state = 'new'
     AND fullForceResult.ff_id IS NULL