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

Written by at
Labels: ,

2 comments:

  1. AnonymousApril 18, 2016 at 9:19 AM

    Hi Simon

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

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

    Regards
    Jan

    ReplyDelete
  2. AndyApril 22, 2016 at 10:46 AM

    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. http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

    ReplyDelete

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.