Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesHi all, Can anyone tell how to join two tables where first table is in db1 and second table in db2.. Looking forward for ur response.. Thanx in advance...
Post Follow-up to this messageSELECT * FROM [DB1].[dbo].[Table1] A JOIN [DB2].[dbo].[Table2] B ON A.[Key] = B.[Key] -- Nik Marshall-Blank MCSD/MCDBA "Prince" <princevictor.moses@gmail.com> wrote in message news:1128077633.696943.139960@z14g2000cwz.googlegroups.com... > Hi all, > > Can anyone tell how to join two tables where first table is in db1 > and second table in db2.. > > Looking forward for ur response.. > > Thanx in advance... >
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread