SELECT *,substr(Tmk,1,10) FROM des_log INNER JOIN des_user_crm ON des_log.UserId=des_user_crm.UserId where des_log.UserId<>'1003' and des_log.UserId<>'1009' group by des_log.UserId,substr(Tmk,1,10) SELECT *,substr(Tmk,1,10) FROM des_log INNER JOIN des_user_crm ON des_log.UserId=des_user_crm.UserId where des_log.UserId<>'1000' and des_log.UserId<>'1008' group by des_log.UserId,substr(Tmk,1,10)