select * from openquery(intedti7, 'Select * from company_cross_ref')

SELECT loc.*, rmt.company_perm_id 

FROM company as loc INNER JOIN 

OPENQUERY(intedti7, 'SELECT * FROM company_cross_ref') as rmt

ON loc.gvkey = rmt.company_ID_value