Changeset 30049 for trunk/ippTools/share/chiptool_find_rawexp.sql

Timestamp:

Dec 15, 2010, 1:29:28 PM (15 years ago)

Author:

watersc1

Message:

Merge of realtime burntool and new nightly science code into trunk.

Location:

trunk

Files:

• . (modified) (1 prop)
• ippTools/share/chiptool_find_rawexp.sql (modified) (1 diff)

trunk/ippTools/share/chiptool_find_rawexp.sql

@@ -1 +1 @@
 -- this query is used to find potental rawExps to be queued for chiptool
 -- processeing
-SELECT
+SELECT DISTINCT 
     rawExp.*,
     newExp.label
 FROM rawExp
 JOIN newExp using (exp_id)
+LEFT JOIN chipRun USING (exp_id)
 WHERE
     rawExp.fault = 0