ifnull嵌套查询练习

语法练习：

SELECT
IFNULL(
IFNULL(
IFNULL(
(
SELECT
CF_ID
FROM
d_customer_fee
WHERE
SITE_ID = ''
AND B_ENABLE = '1'
AND COMPANY_ID = ''
AND SEND_DISTRICT = ''
AND SEND_CITY = ''
AND SEND_PROVINCE = ''
AND CUSTOMER_ID = ''
),
(
SELECT
CF_ID
FROM
d_customer_fee
WHERE
SITE_ID = ''
AND B_ENABLE = '1'
AND COMPANY_ID = ''
AND SEND_CITY = ''
AND SEND_PROVINCE = ''
AND CUSTOMER_ID = ''
)
),
(
SELECT
CF_ID
FROM
d_customer_fee
WHERE
SITE_ID = ''
AND B_ENABLE = '1'
AND COMPANY_ID = ''
AND SEND_PROVINCE = ''
AND CUSTOMER_ID = ''
)
),
(
SELECT
CF_ID
FROM
d_customer_fee
WHERE
SITE_ID = ''
AND B_ENABLE = '1'
AND COMPANY_ID = ''
AND CUSTOMER_ID = ''
)
) AS id

ifnull仅能查询一个字段，否则会报错