SQL SERVER Tips and Tricks

Bookmark
  • Home
  • Video Tutorial
  • Interview Questions
  • Performance Tuning
  • SQL EXAMPLES
Search: 
  Go

Categories

  • Examples (15)
  • INTRODUCTION (14)
  • Join in SQL Server (8)
  • Miscellaneous (5)
  • SQL SERVER COMMANDS (29)
  • SQL SERVER DDL COMMANDS (3)
  • SQL SERVER DML COMMANDS (8)
  • SQL SERVER Error Messages (4)
  • SQL SERVER FUNCTIONS (10)
  • SQL SERVER GENERAL QUESTIONS (28)
  • SQL SERVER GENERAL SCENARIOS (1)
  • SQL Server Installation (1)
  • SQL SERVER Interview Questions (8)
  • sql server performance tuning tips (3)
  • SQL SERVER Tutorial for the Beginners (1)
  • Stored Procedures (20)
  • Templates (6)
  • white papers (1)

Archives

  • ►  2012 (144)
    • ►  January (9)
    • ►  March (2)
    • ►  April (46)
    • ►  May (53)
    • ►  August (26)
    • ►  September (6)
    • ►  November (1)
    • ►  December (1)
  • ▼  2013 (4)
    • ►  February (1)
    • ►  November (1)
    • ▼  December (2)
      • Differences between ISNULL and NULLIF
      • SQL SERVER Tutorial for the Beginners

Pictorial representation of JOIN in SQL SERVER

Posted on Wednesday, 2 May 2012 by SQL Developer

Join between 2 tables  A and B can be represented pictorially as given below:

INNER JOIN :





















LEFT OUTER JOIN or LEFT JOIN:




































RIGHT OUTER JOIN or RIGHT JOIN:





































FULL OUTER JOIN or FULL JOIN:

 














FULL OUTER JOIN WHERE A IS NULL or B IS NULL




























Email ThisBlogThis!Share to XShare to Facebook
Posted in Join in SQL Server | Leave a comment
Newer Posts »
«Older Posts

About

This blog is created to provide complete solutions for all possible problems in SQL SERVER. It contains SQL SERVER Performance techniques, SQL SERVER Interview questions and complete SQL Tips.

Followers

Copyright © 2012 SQL SERVER Tips and Tricks