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