You will often find that you can achieve the same result with a subquery or a join. A join is often more efficient than a subquery (with the exception of when you want to remove duplicates, in which a subquery with NOT EXISTS is more efficient).copy from Microsoft SQL Server 2000 Unleashed
2.自查询是在一个查询所得的结果集中,再查找