SELECT * FROM mems.user u WHERE EXISTS ( SELECT * FROM mems.usertorole WHERE roleId IN ("ADMIN") AND userId = u.userId );
SELECT * FROM mems.user u WHERE EXISTS ( SELECT * FROM mems.usertorole WHERE roleId IN ("ADMIN") AND userId = u.userId );
转载于:https://www.cnblogs.com/0717GG/p/8477670.html