查询每个客户下的进件数量,
SELECT c.id,c.cname,
CASE
(SELECT COUNT(*) FROM t_application a
WHERE a.customer_id=c.id)
WHEN 0 THEN 'none'
WHEN 1 THEN '1'
WHEN 2 THEN '2'
ELSE '3+'
END has_application
from t_customer c;
查询客户下有无进件,只判断关系,不关心数量
SELECT c.id,c.cname,
CASE
WHEN EXISTS(SELECT 1 FROM t_application a WHERE a.customer_id=c.id)
THEN 'Y'
ELSE 'N'
END has_application
from t_customer c;