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
Site Admin
Posts: 143
Joined: 19 Feb 2013, 20:33

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

Traffic Counter

free counters

eXTReMe Tracker