oracle 中的排列的问题

[FEcuckoo]

请问下面的两条SQL在Oracle里面，怎么样这样显示
SCDDATE xssr1 xssr2


SELECT SCDDATE,SUM(XSSR)xssr1 FROM SALECOSTDAY WHERE SCDMKT='201' GROUP BY SCDDATE

SELECT SCDDATE,SUM(XSSR)xssr2 FROM SALECOSTDAY WHERE SCDMKT='202' GROUP BY SCDDATE

[FEcuckoo]

谢谢，两位！

[47522341]

select a.scddate, a.xssr1, b.xssr2
from
(SELECT SCDDATE,SUM(XSSR)xssr1 FROM SALECOSTDAY WHERE SCDMKT= '201 ' GROUP BY SCDDATE ) a ,
(SELECT SCDDATE,SUM(XSSR)xssr2 FROM SALECOSTDAY WHERE SCDMKT= '202 ' GROUP BY SCDDATE) b
where a.scddate = b.scddate(+);

[bugchen888]

SELECT scddate, 
	Sum(Decode(scdmkt,'201',xssr,0) AS xssr1,
	Sum(Decode(scdmkt,'202',xssr,0) AS xssr2
FROM salecostday
GROUP BY scddate