THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Rob Farley

- Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL Server), APS/PDW trainer and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and provides consulting and training courses around the world in SQL Server and BI topics.

Joins in single-table queries

Hi! - Great that you've found this page, but it's no longer here! You can find the content over at:

Published Tuesday, December 11, 2012 11:05 AM by Rob Farley

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Ben Laan said:

Good write up Rob. I was just explaining this exact concept to someone last week - not as well though, so I've just sent him a link to it!

The examples in particular make it quite straight forward.


December 10, 2012 7:24 PM

Ian Yates said:

Great post and excellent examples :)

December 11, 2012 3:18 AM

Matt Velic said:

Very nice post, Rob. Love it!

December 12, 2012 8:43 AM

Rob Farley said:

Let’s start with some basics and then jump in a bit deeper, for this post to go with the 40th T-SQL Tuesday

March 11, 2013 8:20 PM

Leave a Comment


This Blog



No tags have been created or used yet.


News? Haven't you read my blog?

My Company

Can't find something?

Contact Me

Twitter: @rob_farley
Skype: rob_farley

MVP (SQL Server)


Adelaide SQL UG

Privacy Statement