Changeset 27196

Timestamp:

Mar 4, 2010, 3:43:58 PM (16 years ago)

Author:

Paul Price

Message:

Fixing query to include label.

File:

• trunk/ippTools/share/chiptool_definecopy.sql (modified) (1 diff)

trunk/ippTools/share/chiptool_definecopy.sql

@@ -1 +1 @@
 SELECT
-    rawExp.*
+    rawExp.*,
+    newExp.label
 FROM chipRun AS chipOld
 JOIN rawExp USING(exp_id)
+JOIN newExp using (exp_id)
 LEFT JOIN chipRun AS chipNew
     ON chipNew.exp_id = chipOld.exp_id
     AND chipNew.label = '%s'
 WHERE chipNew.chip_id IS NULL
+    AND rawExp.fault = 0