SQL Update Help Needed 1

[brettgab]

I have two tables, Merged_Stock and I_Products. I_Products has a field 'stock_code'. Merged_Stock has two fields, 'old_stock_code' and 'new_stock_code'. I want to write a query which updates I_Products.stock_code with Merged_Stock.new_stock_code. Records will be matched on I_Products.stock_code = Merged_Stock.old_stock_code

 

[tlbroadbent]

Update I_Products
Set stock_code=Merged_Stock.new_stock_code
From I_Products Inner Join Merged_Stock
On I_Products.stock_code = Merged_Stock.old_stock_code Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[brettgab]

Terry you rock