Changeset 19258 for trunk/ippTools/share/difftool_definebyquery.sql

Timestamp:

Aug 27, 2008, 5:57:36 PM (18 years ago)

Author:

eugene

Message:

do not join against tess_id

File:

• trunk/ippTools/share/difftool_definebyquery.sql (modified) (2 diffs)

trunk/ippTools/share/difftool_definebyquery.sql

@@ -24 +24 @@
         diffTemplates.stack_id AS current_stack_id
     FROM warpSkyfile
-    JOIN warpRun USING(warp_id, tess_id)
-    JOIN fakeRun USING(fake_id, tess_id)
-    JOIN camRun USING(cam_id, tess_id)
-    JOIN chipRun USING(chip_id, tess_id)
-    JOIN rawExp USING(exp_id, tess_id)
+    JOIN warpRun USING(warp_id)
+    JOIN fakeRun USING(fake_id)
+    JOIN camRun USING(cam_id)
+    JOIN chipRun USING(chip_id)
+    JOIN rawExp USING(exp_id)
     -- Check if it has an associated diff
     LEFT JOIN diffInputSkyfile AS diffInputs
         ON diffInputs.warp_id = warpSkyfile.warp_id
         AND diffInputs.skycell_id = warpSkyfile.skycell_id
-        AND diffInputs.tess_id = warpSkyfile.tess_id
         AND diffInputs.template = 0 -- only join input files
     -- Get the stack_id currently used as a template, if any
@@ -56 +55 @@
     GROUP BY
         skycell_id,
-        tess_id,
         filter
-    ) AS stacksForDiff USING(skycell_id, tess_id, filter)
+    ) AS stacksForDiff USING(skycell_id, filter)