MS SQL Server - Joining two tables

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Joining two tables

Prince

2005-09-30, 7:23 am

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

Nik Marshall-Blank \(delete fcom for my email addr

2005-09-30, 7:23 am

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

Prince

2005-09-30, 7:23 am

Hi marshall...

Thanx for ur response...

Sponsored Links