>>>Is it possible to include a free table in a spt statement?
>>>something like this:.
>>>sqlexec(nh, " select t1.*, t2.* from testdata.dbo.table1 T1, somefreetable t2 where t1.somefield =t2.somefield ")
>>
>>You can create a linked server to VFP tables or use OPENROWSET() to create it on the fly.
>
>Hi Sergey,
>Can you please be more specific about "create a linked server to VFP tables" ?
>
>Thanks.

Check Configuring Linked server

and

http://www.databasejournal.com/features/mssql/article.php/3085211/Linked-Servers-on-MS-SQL-Part-1.htm