edwardk091997
asked on
Correlated subquery in an update statement?
I have used correlated sub-queries in select statements, -- and I have used embedded selects in update statements, BUT can you you use correlated sub-queries with update statements?
something like:
UPDATE carts SET carts.format_code = prices.format_code
WHERE cart_item_id IN
(SELECT cart_item_id from prices, carts
WHERE blah blah blah.....)
something like:
UPDATE carts SET carts.format_code = prices.format_code
WHERE cart_item_id IN
(SELECT cart_item_id from prices, carts
WHERE blah blah blah.....)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.