select * from(select sum(a.price),
sum(a.tksum),
count(*)from artificialtickets a where a.operid = 199 and a.tktpyeid = 2 and a.drvdate = to_date('2011-10-31', 'yyyy-mm-dd')),(select count(*) from artificialtickets b where b.tkstatusid = 2) 我理解的意思就是你还是要查到一行 移到下面就行了...