Hi Steve,

it looks to me as though you are trying to update the QTY column using a sub query that brings back more than one column. Change the select to assign only one value to the QTY and you should be fine.

is this actually a syntax error and you were trying to use a derived table?

thanks

J