select
CASE WHEN (SELECT COUNT(1) FROM 库名.表名 b WHERE b.id= a.id AND b.sources='03') > 0
THEN '是' ELSE '否' END AS 字段名
from 表名 a where a.字段名 in (.....)
CASE WHEN (SELECT COUNT(1) FROM 库名.表名 b WHERE b.id= a.id AND b.sources='03') > 0
THEN '是' ELSE '否' END AS 字段名
from 表名 a where a.字段名 in (.....)
