Page 1 of 1


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 (maybe, it's a good idea for those who read Arabic or Hebrew :lol: ), it doesn't matter. What is important - always use only one of them.