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.
A big Gracias goes to Juan Carlos Ugaz for allowing me to share this.
A full size version can be seen here
Monday, April 18, 2016
2 comments:
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.
Hi Simon
ReplyDeleteI prefer 'EXCEPTION JOIN' in stead of a test on NULL-value.
One type of join I miss here is 'CROSS JOIN'.
Regards
Jan
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