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

Stats

2.8M views
12.2K downloads
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.

Revisions


  

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

License

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

Share

About the Author

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

Comments and Discussions