select a.*,b.* from (select orderid,ordernumber from [order]) as a, (select orderid,source from [order]) as b where a.orderid=b.orderid
转载于:https://www.cnblogs.com/yansheng/archive/2010/01/05/1639460.html
转载于:https://www.cnblogs.com/yansheng/archive/2010/01/05/1639460.html