如果default_app的icon_url字段不为null且不是空字符串,则取default_app的icon_url,否则取app_info的icon_url字段
SELECT
info.id,info.app_name,
CASE
WHEN
(
ISNULL( dapp.icon_url ) = 0 && ( LENGTH( trim( dapp.icon_url )) > 0 ) ) THEN
dapp.icon_url
else info.icon_url
END as icon_url
FROM
default_app dapp
INNER JOIN app_info info ON dapp.info_id = info.id