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?