SELECT OFU.A,OFU.NUM1,OS.NUM2, CONVERT((DECIMAL(10,2), CONVERT((DECIMAL(10,2),OS.NUM2)/OFU.NUM1)
FROM (SELECT F_A,COUNT(*) NUM1
FROM CR
WHERE F_ITime>= to_date('2008-12-27','yyyy-mm-dd')
AND ITime < to_date('2008-12-27','yyyy-mm-dd')
AND S IN (0,1,2)
AND SType IN (10,17)
HAVING COUNT(*)>0)OFU
INNER JOIN (SELECT A,COUNT(*) NUM2
FROM CR
WHERE ITime>= to_date('2008-12-27','yyyy-mm-dd')
AND ITime < to_date('2008-12-27','yyyy-mm-dd')
AND F_SResult = '110' AND F_ServiceMode IN (0,1,2)
AND F_SType IN (10,17)
GROUP BY A
HAVING COUNT(*)>0)OS ON OS.A = OFU.A
ORACLE怎么写啊？？？？？？？？？？？？
------解决方案--------------------
- SQL code
SELECT OFU.A,OFU.NUM1,OS.NUM2, to_char(to_number(OS.NUM2)/OFU.NUM1, '99999999.99'), FROM (SELECT F_A,COUNT(*) NUM1 FROM CR WHERE F_ITime>= to_date('2008-12-27','yyyy-mm-dd') AND ITime < to_date('2008-12-27','yyyy-mm-dd') AND S IN (0,1,2) AND SType IN (10,17) HAVING COUNT(*)>0)OFU INNER JOIN (SELECT A,COUNT(*) NUM2 FROM CR WHERE ITime>= to_date('2008-12-27','yyyy-mm-dd') AND ITime < to_date('2008-12-27','yyyy-mm-dd') AND F_SResult = '110' AND F_ServiceMode IN (0,1,2) AND F_SType IN (10,17) GROUP BY A HAVING COUNT(*)>0)OS ON OS.A = OFU.A