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.
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.