Monday, April 18, 2016

Examples of SQL joins

I found this posted in a Facebook group. It shows in a simple manner the type of SQL joins and what data they will return.

types of joins using SQL

A big Gracias goes to Juan Carlos Ugaz for allowing me to share this.

A full size version can be seen here


  1. Hi Simon

    I prefer 'EXCEPTION JOIN' in stead of a test on NULL-value.

    One type of join I miss here is 'CROSS JOIN'.


  2. A couple of months ago I found this chart on this web site. It also gives a detailed description of each join. I have found it to be very useful in expanding my SQL knowledge.


To prevent "comment spam" all comments are moderated.
Learn about this website's comments policy here.

Some people have reported that they cannot post a comment using certain computers and browsers. If this is you feel free to use the Contact Form to send me the comment and I will post it for you, please include the title of the post so I know which one to post the comment to.