Changeset 28058 for branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_minidvodbprocessed.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_minidvodbprocessed.sql (modified) (1 diff)

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

@@ -1 +1 @@
 SELECT
     minidvodbProcessed.*,
-    addRun.minidvodb_group
+    minidvodbRun.minidvodb_name 
+    minidvodbRun.minidvodb_group
 FROM minidvodbProcessed
 JOIN minidvodbRun
-    USING(minidvodb_name)
-JOIN addRun
-    USING(minidvodb_name)
+    USING(minidvodb_id)