I am trying to produce a complete alphabetical listing of 2 tables from 2 separate databases - could anyone tell me how to do it. <BR><BR>PS Once I have retrieved the data is it best to store it in a array to manipulate?
I think you mean SQL Server. (Sorry I'm a bit pedantic on this, SQL means Structured Query Language, SQL Server is a MicroSoft product)<BR><BR>You have to add Server2 as a linked server to Server1. Then you can do<BR><BR>SELECT * FROM table1 as T1<BR>INNER JOIN server2.database.owner.table2 as T2<BR>ON T1.SomeId = T2.SomeID<BR><BR>For more info on adding a linked server, see Books Online.<BR><BR>