你这种用法肯定不对的你还不如这样:select * from table a where CONCAT(a.name, a.age) in (select CONCAT(b.name, b.age) from table2 b group by......... )