SELECT email ,
message = ( STUFF(( SELECT ',' + message
FROM taaedi_dbsx
WHERE email = a.email
FOR
XML PATH('')
), 1, 1, '') ) 把多个message 转成一列
FROM taaedi_dbsx AS a
WHERE bill_count > bill_count_old or bill_count1 > bill_count1_old GROUP BY email HAVING email !='a@a.com'
GROUP BY 分组写在 where判断条件的后边
HAVING 写在GROUP BY 后边 HAVING 分组后的判断条件