OUTER JOIN: only LEFT

Share this topic:



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: 111
Joined: 19 Feb 2013, 20:33

Return to Ocean of Databases

Who is online

Users browsing this forum: No registered users and 1 guest


OUTER JOIN: only LEFT

Share this topic:


If you think that this site is not too bad, please LIKE it in Facebook. Thanks!





free counters

eXTReMe Tracker