Well, I thought I had some code lying around, but I guess I updated it with a different process.
In SQL Server's DTS, I had a query that pulled information from our Cicso Call Manager database. Once the data was in my local database, I needed to add a call cost for each call record. To do this, I had another table that had a list of dates and their associated costs for long-distance calls. If a call was made between 1/1/2004 - 1/1/2005, for example, the cost would be $0.05/minute. Then, my UPDATE statement joined the table that needed to be updated, with the other table to get the rates. It worked quite well, but I remember that I changed this process to combine all this information on one select from the Call Manager database. So, as you can see, you can join tables in more than just the SELECT statement. In the SQL Server BOL, you can see that joins are allowed by reviewing the documentation for DELETE. Here is an example: USE pubs DELETE titleauthor FROM titleauthor INNER JOIN titles ON titleauthor.title_id = titles.title_id WHERE titles.title LIKE '%computers%' M!ke -----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, October 20, 2005 8:17 AM To: CF-Talk Subject: RE: WHAT'S WRONG WITH THIS QUERY? I was always under the impression that you couldn't join tables in anything other than a SELECT query. <!----------------//------ andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Nomad [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 19, 2005 6:04 PM To: CF-Talk Subject: WHAT'S WRONG WITH THIS QUERY? Hello, This query works fine with Access. With SQL server it creates an error. Here's the query: UPDATE NewProduct INNER JOIN OldProduct ON NewProduct.dealerpartno = OldProduct.dealerpartno SET NewProduct.details = OldProduct.details Much appreciate any help in debuging. Thanks in advance. Ben ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221641 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
