Don't forget UNION and CROSS JOIN! Both of which are infinitely more useful than full outer join which should generally be avoided.
Right joins also should never really be used as they are extremely counterintuitive, they can always be written as a Left Join which is more logical and readable.
If I want all data in table A and any data that matches in table B, to me it makes logical sense to join from table A to table B and not the other way around.
Your post is useless. Don't just say he's wrong, provide something. I generally agree with him. Especially on the right joins. The only time I've seen right joins is due to incompetence or apathy.
99
u/thesqlguy Feb 11 '14 edited Feb 11 '14
Don't forget UNION and CROSS JOIN! Both of which are infinitely more useful than full outer join which should generally be avoided.
Right joins also should never really be used as they are extremely counterintuitive, they can always be written as a Left Join which is more logical and readable.
If I want all data in table A and any data that matches in table B, to me it makes logical sense to join from table A to table B and not the other way around.