Question

sqlserver2008视图创建出错，求大神帮忙

CREATE VIEW vusermenu
AS
select distinct a.userid AS userid,
a.logincode AS logincode, a.username AS username,
d.menuid AS menuid , d.menuname AS menuname ,
d.pid AS pid , d.menuurl AS menuurl ,
d.menutype AS menutype , d.ordernum AS ordernum ,
d.icon AS icon
from ((users a join rolemenu c )join menu d )
where ((a.roleid = c.roleid ) and (c.menuid = d.menuid ) )
order by d.ordernum
提示：消息 102，级别 15，状态 1，过程 vusermenu，第 9 行
')' 附近有语法错误。

Answer 1

--你的写法有问题 试试这个 而且你整那么多括号干嘛

CREATE VIEW vusermenu
AS
select distinct a.userid AS userid,
a.logincode AS logincode, a.username AS username,
d.menuid AS menuid , d.menuname AS menuname ,
d.pid AS pid , d.menuurl AS menuurl ,
d.menutype AS menutype , d.ordernum AS ordernum ,
d.icon AS icon
from users a , rolemenu c , menu d
where a.roleid = c.roleid and c.menuid = d.menuid
order by d.ordernum

Answer 2

)join 是不是没空格 ) join