sql中把一个查询结果当做一个新表来查询

sql中把一个查询结果当做一个新表来查询

2009-11-18 15:09

举例： 1、select a.stk_c,b.name,cat_c3 from  (select stk_c from stk_dtl where stk_qty>0 group by stk_c) a,stk_mas b where a.stk_c=b.stk_c 2、select * from  (SELECT SUM(NUM_QNTY4) AS sumNum, NUM_LINKID  FROM RW_STORE_QUNTY  GROUP BY NUM_LINKID ) a left join b on a.NUM_LINKID =b.NUM_LINKID  where a.NUM_LINKID = 1002 3、select a.realname,b.username from sa_member a, (select username2 as username,is_agree from sa_MemberFriend where username1='jhgjhg' union all select username1 as username,is_agree from sa_MemberFriend where username2='jhgjhg') b where a.username=b.username