Ok, let me see if I can explain this. I have a Privilege table and a PrivilegeRoleBridge. I want to return the name and ID from the privilege table. In the third column I want to return true or false if the PrivilegeID and the RoleID (passed to this stored proc) are on a row in the bridge. So here is what I have so far (which doesn't work at all)<BR><BR>SELECT Privilege.ID As CurrentID, Privilege.Name, (SELECT Privilege.ID FROM Privilege, PrivilegeRoleBridge WHERE PrivilegeRoleBridge.RoleID = @RoleID AND CurrentID = PrivilegeRoleBridge.PrivilegeID) FROM Privilege ORDER BY Privilege.Name<BR><BR>I believe I am going about this the wrong way. I think I need to create atemporary table and then fill the true and false items in it and then run a query.