Advice about programming, operations, communications, and anything else I can think of
This blog is about IBM i for Power Systems
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
Hi SimonI prefer 'EXCEPTION JOIN' in stead of a test on NULL-value.One type of join I miss here is 'CROSS JOIN'.RegardsJan
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
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.