THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Alexander Kuznetsov

A Great Advice on Coding Predicates in Outer Joins

Yet another very common error is when someone puts a wrong condition in a WHERE clause and that essentially renders an outer join into an inner join. A great advice on coding predicates in outer joins comes from a DB2 expert Terry Purcell.

"Meet the experts: Terry Purcell on coding predicates in outer joins: A comparison of simple outer join constructs"

 

http://www.ibm.com/developerworks/db2/library/techarticle/purcell/0112purcell.html

Enjoy! 

 


 

Published Thursday, May 15, 2008 1:19 PM by Alexander Kuznetsov

Comments

No Comments
New Comments to this post are disabled

About Alexander Kuznetsov

Alex Kuznetsov has been working with object oriented languages, mostly C# and C++, as well as with databases for more than a decade. He has worked with Sybase, SQL Server, Oracle and DB2. He regularly blogs on sqlblog.com, mostly about database unit testing, defensive programming, and query optimization. Alex has written a book entitled "Defensive Database Programming with Transact-SQL" and several articles on simple-talk.com and devx.com. Currently he works as an agile developer.

This Blog

Syndication

Privacy Statement