>>>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.