Changeset 28058 for branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_pendingmergeprocess.sql

Timestamp:

May 20, 2010, 6:27:48 PM (16 years ago)

Author:

heather

Message:

added minidvodb_id, flipmindvodbrun etc

File:

• branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_pendingmergeprocess.sql (modified) (1 diff)

branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_pendingmergeprocess.sql

@@ -2 +2 @@
 FROM minidvodbRun 
 LEFT JOIN minidvodbProcessed
-USING(minidvodb_name)
-WHERE (minidvodbRun.state = 'to_be_merged' AND minidvodbProcessed.minidvodb_name IS NULL)
+USING(minidvodb_id)
+WHERE (minidvodbRun.state = 'to_be_merged' AND minidvodbProcessed.minidvodb_id IS NULL)