OUTER JOIN: only LEFT


Link to this posting

Postby Ursego » 22 Feb 2013, 08:22

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.
User avatar
Ursego
Site Admin
 
Posts: 131
Joined: 19 Feb 2013, 20:33



IF you want to ((lose weight) OR (have unbelievable (brain function AND mental clarity))) THEN click:




cron
free counters

eXTReMe Tracker