Page 1 of 1

OUTER JOIN: only LEFT

PostPosted: 22 Feb 2013, 08:22
by Ursego
Use only left outer join.

Writing OUTER JOINs, use only LEFT ones all over the application (even all over your career if it's possible) - and never RIGHT! It will facilitate imagining of the joined tables: the left imagined table always has values in all the rows, and the right one has "holes" of NULLs... Oppositely, you can always use RIGHT and never LEFT, it doesn't matter, what is important - use only one of them (no politics, really! :lol: ).