I have sqlserver 2008, called 'Server A'. It has a linked server setup. How
do I select from table in the linked server from 'Server A'. I can so it
with Use, but my select statement ref tables from both servers.

TIA

Phil Hunt (aaa (AT) aaa (DOT) com) writes:
SELECT ..
FROM thelinkedserver.thatdb.dbo.thattbl a
JOIN yourlocaltbl b ON a.somekey = b.somekey


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

I am doing this from the Studio, what you wrote does not work. Do I need
OPENQUERY ?
That's what I found when I google

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Phil Hunt (aaa (AT) aaa (DOT) com) writes:

Since I just made up the table names and the query pattern, I am not
surprised that the query didn't work. Then again, you were supposed
to adapt the pattern to you query and work from there.

All I know now is that you have a query (well, at least I assume that you
have) and it "does not work". But I know how that query looks like, I don't
know what "does not work" means. Thus, I'm quite of my powers to help you,
unless you help me to help you. Please post your query, and explain why
you are not satisfied with it. If you get an error message, please include
the error message.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

On Fri, 02 Sep 2011 23:48:31 +0200, Erland Sommarskog
<esquel (AT) sommarskog (DOT) se> wrote:

OP, Erland has given a lot of people a lot of help, but he needs
information to be able to help effectively. I suggest that you read
the following guide. It explains how to ask technical questions in a
way that works:
http://www.catb.org/~esr/faqs/smart-questions.html
Following it, you might be able to solve the problem yourself, but
even if not, you will have much more data to include in your post.

Sincerely,

Gene Wirchenko

It actually worked, although my 4 part names was underlined red as invalid
object.


"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote