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



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
Anonymous comments are disabled

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