select distinct p.pid,p.name FROM
permission p
where p.pid
not in (SELECT pid from per_role where rid = 1)
筛选两张表中id不同的数据
最新推荐文章于 2023-02-11 11:21:17 发布
select distinct p.pid,p.name FROM
permission p
where p.pid
not in (SELECT pid from per_role where rid = 1)