SqlServerKudos - The Self Join – Inner Join and Outer Join - An Example

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

1
kudos

Kudos

The Self Join – Inner Join and Outer Join - An Example

published 674 days, 16 hours, 3 minutes ago posted by

pinaldave 683 days, 23 hours, 33 minutes ago

The Self Join – Inner Join and Outer Join - An Example

Self Join has always been an note-worthy case. It is interesting to ask questions on self join in a room full of developers. I often ask – if there are three kind of joins, i.e.- Inner Join, Outer Join and Cross Join; what type of join is Self Join? The usual answer is that it is an Inner Join. In fact, it can be classified under any type of join.

Read more for example.

category: Query | clicked: 3 | | source: blog.sqlauthority.com | show counter code

tags: pinaldave, SQL, SQLAuthority, SQLServer

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

SqlServerKudos