HELP !!!! SQL SYNTAX PROBLEM - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

HELP !!!! SQL SYNTAX PROBLEM

Author

Topic

mossse
Starting Member

4 Posts

Posted - 2009-04-08 : 11:35:07

Hi
What is wrong with this select sql

select * from SETUP_MENU where itemId in
(
select menuid from SETUP_MENU_ROLES m
inner join PEOPLE_ROLES s
on s.RoleId = M.roleId
and s.PersonId = "251"
on s.RoleId = M.roleId
where (MenuParent is null or MenuParent = 0)
group by menuid
)
order by MenuOrder

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2009-04-08 : 11:54:06

[code]select * from SETUP_MENU where itemId in
(
select menuid from SETUP_MENU_ROLES m
inner join PEOPLE_ROLES s
on s.RoleId = M.roleId
and s.PersonId = '251'
and s.RoleId = M.roleId
where (MenuParent is null or MenuParent = 0)
group by menuid
)
order by MenuOrder[/code]

mossse
Starting Member

4 Posts

Posted - 2009-04-08 : 12:02:08

This did not work in access
help!!!

select * from SETUP_MENU where itemId in
(
select menuid from SETUP_MENU_ROLES m
inner join PEOPLE_ROLES s
on s.RoleId = M.roleId
and s.PersonId = '251'
and s.RoleId = M.roleId
where (MenuParent is null or MenuParent = 0)
group by menuid
)
order by MenuOrder

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2009-04-08 : 15:22:16

You posted it in a sql server 2008 forum. How would it occur to me that you want an access syntax.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources