SQL JOINing a Table to Itself

(Lorna Mitchell) Getting two sets of information from one table in a select statement often leads people to write subselects, but it really doesn’t matter that this is the same table twice, we can just give it a new alias and treat it as if it were a different table.

Read More - Register for Free Membership