Openquery join two tables

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;

Source: stackoverflow.com

Similar codes

0 vote367 views1 answer
Is not numeric sql
SQL
7 votes356 views3 answers
Convert ansi sql
SQL
0 vote309 views1 answer
Mysql group rows with same value
SQL
0 vote306 views1 answer
Duplicate foreign key constraint name
SQL
0 vote314 views1 answer
Time in sql server
SQL
11 votes308 views1 answer
Reset identity sql server
SQL
0 vote347 views2 answers
Get top 1 row of each group
SQL
0 vote355 views3 answers
Join
SQL
0 vote388 views1 answer
What is metadata in sql
SQL
0 vote333 views1 answer
Jdbc sql connection string
SQL