query between 2 servers/databse

query between 2 servers/databse

 

  

List


Can you help me to figure out how to go in writing a query a select or a
insert combining 2 tables from more than 1 database .What's the syntax .

For example :

1. I need to write a select for a table joining a table from a pubs and
northwind .

2. How can I combine a single query from 2 database server .

Nirmal


MS Sql Server LazyDBA home page