I have several connected databases, which I canNOT alter. I can NOT get anyone to establish sever links. 
All the ones I want to connect are SQLServer.
See attached Image.
They have related, but different, business data.
Can I write a query in any of them to select data from several connections at once?
I tried GoldPoint . dbo . <DBname> . <table>
LEFT JOIN NLS . <DBname> . <table>
Did not work
Any ideas? is it even possible?
Thanks all in advance!
All the ones I want to connect are SQLServer.
See attached Image.
They have related, but different, business data.
Can I write a query in any of them to select data from several connections at once?
I tried GoldPoint . dbo . <DBname> . <table>
LEFT JOIN NLS . <DBname> . <table>
Did not work
Any ideas? is it even possible?
Thanks all in advance!
Comment