How to join linked server tables with openquery

Question

I want to join tables from two different linked servers. I am not sure how to do that.

First query:

SELECT * FROM OPENQUERY(PANTS,'
SELECT
LONG
,SHORT
FROM JEANS

Second query:

SELECT * FROM OPENQUERY(SHIRTS,'
SELECT 
WHITE
,BLACK 
 FROM STORES

Let's say long is in the stores table and I want to join on it. How would I do that?

mendosi · Accepted Answer · 2016-11-17 02:11:36Z

2

According to the query you supplied, you could do it like this:

Select Pants.Long, Pants.Short,
    Shirts.White, Shirts.Black
  From OpenQuery(PANTS, 'Select Long, Short From Jeans') As Pants
  Join OpenQuery(SHIRTS, 'Select White, Black, Long From Stores') As Shirts 
    On Pants.Long = Shirts.Long;

answered Nov 17, 2016 at 2:11

mendosi

2,0611 gold badge14 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to join linked server tables with openquery

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related