oracle 将查询的两行结果拼接

Question

解决了！哈哈！SELECT 
       (select count(1)  from GcdCustomerMain ) AS customerYear,
       (SELECT COUNT(1) FROM GcdCustomerMain c  WHERE  trunc(c.createdate,'mm') = trunc(SYSDATE,'mm'))AS customerMonth,
       (SELECT COUNT(1) FROM GcdCustomerMain c  WHERE  trunc(c.createdate,'dd') = trunc(SYSDATE,'dd'))AS customerDay,
       (select count(1)  from Gcdbusiness) AS businessYear,
       (SELECT COUNT(1) FROM Gcdbusiness b WHERE  trunc(b.createdate,'mm') = trunc(SYSDATE,'mm'))AS businessMonth,
       (SELECT COUNT(1) FROM Gcdbusiness b WHERE  trunc(b.createdate,'dd') = trunc(SYSDATE,'dd'))AS businessDay,
       (SELECT SUM(b.UNDWRTPREMIUM) FROM Gcdbusiness b WHERE trunc(b.createdate,'Y') = trunc(SYSDATE,'Y'))AS undwrtYear,
       (SELECT SUM(b.UNDWRTPREMIUM) FROM Gcdbusiness b WHERE trunc(b.createdate,'mm') = trunc(SYSDATE,'mm'))AS undwrtMonth,
       (SELECT SUM(b.UNDWRTPREMIUM) FROM Gcdbusiness b WHERE trunc(b.createdate,'dd') = trunc(SYSDATE,'dd'))AS undwrtday
FROM GcdCustomerMain c ,Gcdbusiness b
WHERE  trunc(b.createdate,'Y') = trunc(SYSDATE,'Y')
GROUP BY  trunc(SYSDATE,'dd')