Click here to Skip to main content
14,637,779 members
Articles » Database » Database » SQL » Revisions


554 bookmarked

Visual Representation of SQL Joins

Rate this:
4.96 (445 votes)
Please Sign up or sign in to vote.
4.96 (445 votes)
3 Feb 2009CPOL
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
This is just a simple article visually explaining SQL JOINs. In this article I am going to discuss seven different ways you can return data from two relational tables. The seven Joins I will discuss are: Inner JOIN, Left JOIN, Right JOIN, Outer JOIN, Left Excluding JOIN, Right Excluding JOIN, Outer Excluding JOIN, while providing examples of each.



Compare Revision Minor Date Status Editor
10 - publicly available Yes 11-Feb-20 9:13 Available Sean Ewington
Updates in content. Changes: 294
8 No 3-Feb-09 21:50 Available Smitha Nishant
7 No 3-Feb-09 21:50 Composing
6 No 3-Feb-09 21:50 Composing
5 No 3-Feb-09 21:50 Composing
4 No 3-Feb-09 16:11 Composing
3 No 3-Feb-09 16:11 Composing
2 No 3-Feb-09 16:11 Composing
1 No 3-Feb-09 16:11 Composing


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

C.L. Moffatt
Green Sand Software
United States United States
No Biography provided

Comments and Discussions