SELECT *FROM mems.user uWHERE EXISTS ( SELECT * FROM mems.usertorole WHERE roleId IN ("ADMIN") AND userId = u.userId);
本文共 184 字,大约阅读时间需要 1 分钟。
SELECT *FROM mems.user uWHERE EXISTS ( SELECT * FROM mems.usertorole WHERE roleId IN ("ADMIN") AND userId = u.userId);
转载于:https://www.cnblogs.com/0717GG/p/8477670.html