原sql
IF(A.SOURCE_TYPE = 1,
(SELECT IFNULL(SUM(G.AMOUNT), 0)
FROM OIS_BILL F,
OIS_BILL_DETAILS G
WHERE F.BIZ_NO = A.ORDER_NO
AND F.STATUS = 1
AND F.BILL_ID = G.BILL_ID
AND F.OPC_ID = A.REG_ID),
(SELECT IFNULL(SUM(PRICE * NUM), 0)
FROM CIS_ORDER_FEE F
WHERE F.ORDER_NO = A.ORDER_NO
AND F.IN_VISIT_ID = A.REG_ID)) REQUEST_FEE