Create Table myCountries (country c(10)) Insert into myCountries values ('USA') Insert into myCountries values ('Germany') Insert into myCountries values ('Canada') use lnHandle=SQLStringConnect('DRIVER=SQL Server;SERVER=servername;Trusted_connection=Yes') SQLExec(lnHandle, ; "select * from Northwind.dbo.customers as rmtR"+; " inner join OPENROWSET('VFPOLEDB.1', "+; " '"+Sys(5)+Curdir()+"';'';'',"+; " 'select * from myCountries') as locR"+; " on rmtR.country = locR.country",'myResult' ) SQLDisconnect(lnHandle)Cetin