I will give it a try. Thanks a lot Phillip B.
www.LoungeRoyale.com www.FillWorks.com ----- Original Message ----- From: "Andy Ewings" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 09, 2003 11:55 AM Subject: RE: update query > Hi > > If the link is ID then your query looks ok the following will do it..... > > UPDATE tableA > SET > region = TableB.region > FROM tableB, TableA > WHERE tableB.id = tableA.id > > -----Original Message----- > From: Phillip B [mailto:[EMAIL PROTECTED] > Sent: 09 July 2003 17:40 > To: CF-Talk > Subject: Re: update query > > > That is what I would normally do but it has to be part of a DTS package and > will be ran everyday :( > > Phillip B. > > www.LoungeRoyale.com > www.FillWorks.com > ----- Original Message ----- > From: "Tony Weeg" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, July 09, 2003 11:25 AM > Subject: RE: update query > > > > I would do a cfquery of all columns in b. > > > > then loop through that, for each iteration, update > > a with the value of some b query column value. > > > > make sense? > > > > tony weeg > > uncertified advanced cold fusion developer > > tony at navtrak dot net > > www.navtrak.net > > office 410.548.2337 > > fax 410.860.2337 > > > > > > -----Original Message----- > > From: Phillip B [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, July 09, 2003 12:21 PM > > To: CF-Talk > > Subject: OT: update query > > > > > > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
