Joining tables from different dbs 1

[shyamal]

Just curious, is this possible regardless of Sybase or NT server.

If I have table A in DB1 and table A in DB2 can these be joined as long as there are common fields i.e. Sales_Id exists in both tables, If so how can this be done? I was just curious, this is a longshot. I was transferring data from one db to another db and just thought that there had to be other alternatives to my method.

 

[jerasi]

Yes, and the syntax for that is:

SELECT db1.col_1, db2.col_2
FROM DB1.dbo.A db1 INNER JOIN DB2.dbo.A db2 ON db1.col_id = db2.col_id

I hope this answers your question.
Regards.

 

[shyamal]

Thanks Jerasi!