"select statement cannot compare one data with multiple data"

[sangam56]

Hello!I am using following sql statement:
SELECT Menu.MenuID,Menu.TextUrl FROM Menu WHERE
Menu.MenuID= (SELECT Permissions.MenuID FROM Permissions WHERE
Permissions.RoleID=(SELECT Roles.RoleID FROM Roles WHERE
Roles.RoleName=@inputRoleName))
I am using three tables: Roles, Permissions, and Menu.
The error reads like: use of =,<,> etc cannot compare with multiple results.
In fact second SELECT statement returns multiple MenuID and I need all the possible row from the first SELECT statement.

Is there any way to write the correct sql statement? Please help me. Thanks.

[amitpatel66]

Hello!I am using following sql statement:
SELECT Menu.MenuID,Menu.TextUrl FROM Menu WHERE
Menu.MenuID= (SELECT Permissions.MenuID FROM Permissions WHERE
Permissions.RoleID=(SELECT Roles.RoleID FROM Roles WHERE
Roles.RoleName=@inputRoleName))
I am using three tables: Roles, Permissions, and Menu.
The error reads like: use of =,<,> etc cannot compare with multiple results.
In fact second SELECT statement returns multiple MenuID and I need all the possible row from the first SELECT statement.

Is there any way to write the correct sql statement? Please help me. Thanks.

Try this:

 
SELECT Menu.MenuID,Menu.TextUrl FROM Menu WHERE
Menu.MenuID IN  (SELECT Permissions.MenuID FROM Permissions WHERE
Permissions.RoleID IN (SELECT Roles.RoleID FROM Roles WHERE 
Roles.RoleName=@inputRoleName))
 
 

[sangam56]

Try this:

 
SELECT Menu.MenuID,Menu.TextUrl FROM Menu WHERE
Menu.MenuID IN  (SELECT Permissions.MenuID FROM Permissions WHERE
Permissions.RoleID IN (SELECT Roles.RoleID FROM Roles WHERE 
Roles.RoleName=@inputRoleName))
 
 

Thanks!! It worked well. Thanks again!!

[amitpatel66]

Thanks!! It worked well. Thanks again!!

You are welcome :)

Amit