select group_concat(USERIDCARDHASH separator ';') from (
select a.*,'1' grouid from transact a left join userinfo b on a.USERIDCARDHASH = b.USERIDCARDHASH where b.BUSI_ID is null
) aa group by grouid;
转载于:https://www.cnblogs.com/Struts-pring/p/11037654.html