Changeset 27195 for trunk/ippTools/share

Timestamp:

Mar 4, 2010, 3:37:08 PM (16 years ago)

Author:

Paul Price

Message:

Fixing query for chiptool -definecopy

File:

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

trunk/ippTools/share/chiptool_definecopy.sql

@@ -3 +3 @@
 FROM chipRun AS chipOld
 JOIN rawExp USING(exp_id)
-LEFT JOIN chipRun AS chipNew 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