As everybody know SQL is what I like most. Before I was into SQL Server, I was very much into ColdFusion. ColdFusion is still my most favorite programming language. I still program in ColdFusion, infect my personal website http://www.pinaldave.com is in ColdFusion. I regularly read ColdFusion blog and latest updates in ColdFusion. Recently at company where I work, we upgraded to ColdFusion 8 and .NET 2.0 (C# is our preferred language in .NET technology). Both of this languags work with SQL Server 2005 very well in my company.
My favorite blog for ColdFusion technology is blog of BEN NADEL . Ben writes excellent articles in ColdFusion and have absolutely control over his technical thought process - a true genius. Recently he wrote two articles about how SQL JOINS can be used in UPDATE and DELETE queries. When I read them I felt I should have wrote similar articles for this blog.
Please visit both the articles to get the proper understanding how JOIN can be used. The code is SQL with great amount of explanation.
Using A SQL JOIN In A SQL UPDATE Statement
This example is explained with UPDATE and INNER JOIN.
Using A SQL JOIN In A SQL DELETE Statement
This example is explained with DELETE and LEFT OUTER JOIN. Very good example.
If you on the site of Ben Nadel, checkout the Free ColdFusion Calender System.
Let me know what you think about these articles.
Pinal Dave (http://www.SQLAuthority.com)
pinaldave
Pinal Dave, thank you very much for the kind words and the most excellent SQL advice :)
It’s a really good tip about update. I am wondering if we need to join the same table several times. will the aliases work on the update query? If you have the answer, could you please email it to me. I am getting stuck. Thanks.
thanked post