Only using Left Outer Joins

Mr_Shaw
Mr_Shaw used Ask the Experts™
on
I having been looking into the idea of only using Left Outer Joins.

I read in the following blog http://weblogs.sqlteam.com/jeffs/archive/2008/02/13/on-right-outer-joins.aspx  (see first response)

“If a right outer join seems required to make your query work, you should re-write it”.

Further on in the blog Jeff has mentioned one way of re-writing a right outer join would be to use a nested join.

Are there any other methods apart from nested joins which I could use to bypass right outer joins?
 
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
HainKurtSr. System Analyst
Commented:
sometimes outer joins are necessary and there may no way to change the underlying data structure...
what data structure you have and what are you trying to do? can you give us solid examples...

Author

Commented:
I do not have any examples to give, I am just researching the issue.

I have been writing sql for couple of years now and the idea of not using Right Outer Joins completly passed me by!
Information Technology Specialist
Commented:
While I can't remember the last time I used a right join, I don't think it's because it's necessarily better to use only left joins. I think it's more because we're used to reading from left to right and top to bottom that makes using left joins more intuitive. However, we're also dealing with systems that only care if the light is off or the light is on, and not whether the light switch is in the up or down position, so I can't imagine there is a substantial difference in performance from one way to the other.
HainKurtSr. System Analyst
Commented:
on my previous post I was mentioning about outer joins (not specifically the right outer join), thinking exactly as awking00 ;)

left outer join = right outer join if we reverse the table names too ;)

Author

Commented:
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial