Changeset 31596 for trunk/ippTools/share/addtool_find_sky_id_dvo.sql

Timestamp:

Jun 1, 2011, 5:33:35 PM (15 years ago)

Author:

heather

Message:

addtool -definebyquery didn't do what we wanted with -filter and -stage
staticsky. It now does. The cam search things are only used on cam stage (not
stack or staticsky, where it doesn't make sense)

File:

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

trunk/ippTools/share/addtool_find_sky_id_dvo.sql

@@ -1 +1 @@
 SELECT staticskyRun.* FROM staticskyResult
 JOIN staticskyRun USING(sky_id)
+join staticskyInput using(sky_id)
+JOIN stackRun USING(stack_id)
+
 WHERE staticskyRun.state = 'full' and staticskyResult.quality = 0
     AND sky_id NOT IN (SELECT sky_id