多个Select语句合并

select a.*,b.* from (select orderid,ordernumber from [order]) as a, (select orderid,source from [order]) as b where a.orderid=b.orderid