Changeset 30102 for branches/eam_branches/ipp-20101205/ippTools/share/chiptool_find_rawexp.sql

Timestamp:

Dec 17, 2010, 10:05:43 AM (16 years ago)

Author:

eugene

Message:

merge from trunk

File:

• branches/eam_branches/ipp-20101205/ippTools/share/chiptool_find_rawexp.sql (modified) (1 diff)

branches/eam_branches/ipp-20101205/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