Hmmmm, I think you want a join instead. Try something like this:

SELECT User_Id,User_Name,Ms_Menu.Menu_Id,Menu_Name
FROM dbo.Ms_Menu LEFT OUTER JOIN dbo.Tbl_User ON Ms_Menu.Menu_Id =...

I'm having a problem querying data from two different databases on a SQL 2000 server. We have two databases, a main data db, and a separate security db that has login info.

Database logins for...