Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

get the data from more than one database

2 Posts 2 Posters 0 Views 1 Watching

L Offline
L Offline
luckyv

wrote on last edited by

#1

Hi all, I want to get the data from tables of two different database.Is it possible Pls help thanks lucky
R 1 Reply Last reply

0
L luckyv

Hi all, I want to get the data from tables of two different database.Is it possible Pls help thanks lucky
R Offline
R Offline
Rana Muhammad Javed Khan

wrote on last edited by

#2

you can select data from tables in different databases as: Select A.Flds , B.Flds From Server1.db1.dbo.Table1 A Inner Join Server1.db2.dbo.Table1 B A.Fld = B.Fld Regards, Javed
1 Reply Last reply

0

Log in to reply