Re: Problem with Nested Inserts

[Jay Pipes]

Error message is quite clear. The subquery returns more than one row. Since you are using the equality operator, the subquery is expected to return a single value, to compare to the bcode field. You should change the = to IN or better yet, use a join, which is generally more efficient:

INSERT INTO a (a4, a5, a6)
SELECT b3, b6, b7
FROM b
INNER JOIN a
ON b.bcode = a.acode;

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com