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.
| Author |
Topic |
|
mossse
Starting Member
4 Posts |
 Posted - 2009-04-08 : 11:33:08
|
| Hi What is wrong with this select sqlselect * 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 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
HELP !!!!! SQL SYNTAX PROBLEM