语法练习:
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仅能查询一个字段,否则会报错