Hi..

I want to write a query which is using two source tables. The tables are located at different database which are located at different SQL server instance.

The detail is as follow :

TableA is located inside DatabaseA at SQLServerA

TableB is located inside DatabaseB at SQLServerB

The query uses TableA and TableB.

Anybody know how to write the query ? Please advise..

Thank you.