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, it doesn't matter, what is important - use only one of them (no politics, really! :lol: ).
User avatar
Ursego
Site Admin
 
Posts: 112
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