I have two tables. tableA id name region
tableB id name region I need to update tableA's region colum with tableB's region colum. The region colum has changed for some and not for others. With that said, does this look right? UPDATE tableA SET region = (SELECT region FROM tableB WHERE tableB.id = tableA.id) Its been a while since I have done this and I cant remeber the best way to do it. :| Phillip B. www.LoungeRoyale.com www.FillWorks.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4