SQL Server‎ > ‎

Syntax to query a remote linked server

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

Comments