Gossamer Forum
Home : General : Databases and SQL :

SQL Query

Quote Reply
SQL Query
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.
Quote Reply
Re: [nidhish] SQL Query In reply to
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?