Changeset 33003 for branches/haf_add201112/ippTools/share/minidvodbtool_find_minidvodb_id_dvo.sql

Timestamp:

Dec 22, 2011, 2:21:40 PM (15 years ago)

Author:

heather

Message:

whoo hooo! mergetool changes, now to test on maui

File:

• branches/haf_add201112/ippTools/share/minidvodbtool_find_minidvodb_id_dvo.sql (modified) (1 diff)

branches/haf_add201112/ippTools/share/minidvodbtool_find_minidvodb_id_dvo.sql

@@ -1 +1 @@
 SELECT minidvodbRun.* FROM minidvodbRun
 JOIN minidvodbProcessed USING(minidvodb_id)
-WHERE minidvodbRun.state = 'merged'
+WHERE minidvodbRun.state = 'merged'     
+      AND minidvodbProcessed.fault = 0
     AND minidvodb_id NOT IN (SELECT minidvodb_id
        FROM minidvodbCopy