Select st.*, vt.myField from SQLserverTable as st inner join OPENROWSET('VFPOLEDB', 'c:\myPath\myDB.dbc';'';'','select * from VFPTable') as vt on st.Id = vt.IdUpdate : 2 view declarations using SQL and VFP tables (for an in (...) query) :
CREATE SQL VIEW "CUSINSPECIFICCOUNTRY" ; REMOTE CONNECT "SQLNW" share ; AS SELECT rmtR.* FROM Customers as rmtR ; inner join #myCountries as locR ; on rmtR.country = locR.countryName CREATE SQL VIEW "CUSINSPECIFICCOUNTRY" ; REMOTE CONNECT "SQLNW" share ; AS SELECT rmtR.* FROM Customers as rmtR ; inner join OPENROWSET('VFPOLEDB.1', 'd:\cetin\ddrive\temp\InQuery.dbc';'';'','select * from myCountries') as locR ; on rmtR.country = locR.cntryNameFirst one creates temp table on SQL server while the second uses OpenRowSet.