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 vote274 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote256 views1 answer
Soql more than today
SQL
16 votes281 views1 answer
Mysql reset auto increment value
SQL
0 vote266 views1 answer
Soql user profile
SQL
-1 vote265 views2 answers
Get day in sql
SQL
19 votes297 views5 answers
Display table in sql
SQL
3 votes259 views1 answer
How to uninstall microsoft sql server
SQL
46 votes319 views4 answers
Create column sql
SQL
0 vote297 views1 answer
Distance calculator from lat long sql query
SQL
2 votes235 views1 answer
Latest record in sql
SQL