Tuesday February 9th

Monday February 8th

Why to avoid FULL OUTER JOINS -- and what to use instead

Using FULL OUTER JOINS results in sloppy, inefficient SQL, with no true structure and NULLS in potentially every column in the results. Here's some better ways to write your SELECT if you think you might need to use a FULL OUTER JOIN.

2 comments

Good one. Glad I always stayed away from outer joins.

>> Good one. Glad I always stayed away from outer joins.

Yikes! don't stay away from outer joins in general, stay away from FULL outer joins. LEFT OUTER JOINs are very important to understand and use when writing SQL !!!

Commenting on Stories is limited for now and will open up to those recommended by the community. Learn how
Loading DotNetKicks...
brought to you by the Kicks Network