>>>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 ")
>>
>>See if this thread Re: How to update dbf from Openrowset? Thread #1368838 can be helpful.
>
>Thanks Naomi,

You're welcome.