第7章 子查询-.pdfVIP

IT 3 Sept. 2008Copyright 2008 By Neusoft Group. All rights reserved © Neusoft Confidential 3 Sept. 2008 Confidential • • • • 3 Sept. 2008 Confidential Chen “Chen?” ? ? ? ? “Chen?” 3 Sept. 2008 Confidential • SELECT SELECT FROM FROM WHERE WHERE (SELECT (SELECT FROM ); FROM ); • SubqueryInner QueryMain query Outer query 3 Sept. 2008 Confidential • Chen • – – – WHEREHAVINGFROM – ORDER BY 3 Sept. 2008 Confidential CLERK CLERK CLERK CLERK