CODE EXAMPLE FOR SQL

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;