现在开发项目的sql写法——涉及很广
上一篇 /
下一篇 2011-04-01 17:38:55
/ 个人分类:数据库资料
select
sys_company.companyid,
sys_user_roles.roleid,
sys_role_rights.menuid,
sys_menu.name
from sys_user
INNER join sys_company on sys_company.companyid=sys_user.companyid
INNER join sys_user_roles on (sys_user_roles.userid=sys_user.userid and sys_user_roles.companyid=sys_user.companyid)
INNER join sys_role_rights on (sys_role_rights.companyid=sys_company.companyid and sys_role_rights.roleid=sys_user_roles.roleid)
INNER join sys_menu on sys_menu.menuid=sys_role_rights.menuid
where sys_user.userid=10
GROUP BY sys_menu.menuid ORDER BY sys_menu.menuid DESC
设计到5张表的查询;
收藏
举报
TAG: