Join Blogs & Blog Posts
Posting Frequency on join
|
Distinct: |
Percent: |
Latest Blog Posts on join
- The Weird Syntax of SQL DELETE From a JOIN by McBean Information Technology on May 22, 2009
It is perfectly legal in most SQL dialects to DELETE records that come from a JOIN clause. However, I never remember the syntax because its kind of strange and I don't do it often.I wrote the following example in SQL Server 2005:delete from arledger...
- SQL Update with JOIN by McBean Information Technology on Dec 30, 2008
I was trying to remember how to do an SQL UPDATE statement using fields from a JOIN. Its one of those things I don't do very often, and the syntax is not exactly intuitive. Its a good example of the power of SQL.The general template for such a statem...
