Sql 一些特殊的查询

 

1.视图查询：

select tabC.*,tabA.* from 
(select r.resource_id,r.resource_parent,r.resource_name,p.role_id from up_resource r right join up_privilege p on r.resource_id=p.resource_id ) tabA,
(select ro.role_id from up_userinfo u inner join up_userrole ro on u.userinfo_id=ro.userinfo_id ) tabB,
(select * from up_info) tabC
where tabA.role_id in(tabB.role_id) and tabC.resource_id in(tabA.resource_id)