"select statement cannot compare one data with multiple data"

[sangam56]

Hello!I am using following sql statement:
SELECT Menu.MenuID,Men u.TextUrl FROM Menu WHERE
Menu.MenuID= (SELECT Permissions.Men uID FROM Permissions WHERE
Permissions.Rol eID=(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,Men u.TextUrl FROM Menu WHERE
Menu.MenuID= (SELECT Permissions.Men uID FROM Permissions WHERE
Permissions.Rol eID=(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:

[code=sql]

SELECT Menu.MenuID,Men u.TextUrl FROM Menu WHERE
Menu.MenuID IN (SELECT Permissions.Men uID FROM Permissions WHERE
Permissions.Rol eID IN (SELECT Roles.RoleID FROM Roles WHERE
Roles.RoleName= @inputRoleName) )

[/code]

[sangam56]

Try this:

[code=sql]

SELECT Menu.MenuID,Men u.TextUrl FROM Menu WHERE
Menu.MenuID IN (SELECT Permissions.Men uID FROM Permissions WHERE
Permissions.Rol eID IN (SELECT Roles.RoleID FROM Roles WHERE
Roles.RoleName= @inputRoleName) )

[/code]

Thanks!! It worked well. Thanks again!!

[amitpatel66]

Thanks!! It worked well. Thanks again!!

You are welcome :)

Amit