This is a very good question, is there actually a difference. There is none! However I would suggest to always use LEFT OUTER JOIN to remind yourself that this is actually outer join.

LEFT, RIGHT and FULL outer joins are the only types of OUTER JOIN.

Dima Svirid

Software architect, JAVA, Spring, Hibernate, AngularJs, Backbone, MongoDB, Oracle. CTO and Co-Founder of Homeadnet.com

More Posts

Follow Me:

Tagged with: