Home > Sql Server > Learning Sql Server Joins In Form of Venn Diagrams

Learning Sql Server Joins In Form of Venn Diagrams


Learn Basic Concepts of Sql joins like
Inner Join
Outer Join
Cross Join
Self Join

etc..
in the most simpler manner by pinal dave in the form of venn diagram.
He has explained sql joins with proper examples.. very good article for newbies on sql server

http://dotnetslackers.com/articles/sql/SQL-SERVER-JOINs.aspx

Advertisements
  1. teresa
    July 15, 2009 at 1:55 pm

    The Venn diagrams explain joins for *any* database, all you need is the syntax for each one.

    I’ve been searching and searching for Venn diagrams, and finally! Thank you for posting this! It totally helps me to see the joins in my mind and get a handle on ‘minus’ and other things it’s hard for me to visualize. Oh, and I’m originally Oracle, that’s why I say this is good for any DB.

    Thanks!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: