>I never even realized you could do a 'Self Join' !!

Yeah, it's a useful technique. Another place you might use it is in an employee database where each employee has a manager, who is also an employee.