Hi
I need urgent help in running a MS SQL query.
I have to access data from two different databases residing on the same SQL Server. Ex:The comparison to be made in the query looks like this, db1.table1.field1=db2.table2.field1

I have tried using VB and MS SQL query analyzer, but both allow one database to get activated for use at a time.
Please help.

why not get data from one database and store it and then use that stored data to compare to the other databases data?
Don't know if ur using a database or just an app to connect to the database?