>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 ")
No, you need to use
Openrowset instead.
If it's not broken, fix it until it is.
My Blog 
