I need to set the value of one field in table tblA to the value in table tblB with id being the same in both tables. Would this work?
UPDATE tblA SET brand = (SELECT brand FROM tblB WHERE tblB.id= tblA.id) I'm using SQL2000. Phillip B ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
