Hi Michael,

Thanks for the info. On a related note, I have another question. (Sorry if this should go in another thread)

I know that using the *= syntax is considered outdated. But I tried this:

select distinct arcust.ccustno, sosord.ccustno as xcustno from arcust, sosord where arcust.ccustno *= sosord.ccustno

in t-sql and vfp. I get 'missing operand' in vfp 6. I seem to recall doing queries this way in foxpro several years ago? Am I mistaken.

>The additional FROM is a TSQL Extension, it is not supported by ANSI SQL.
>
>-Mike
>
>
>>I am writing a T-SQL stored procedure that uses the FROM clause in an update statement. I wanted to test the equivalent functionality in VFP. But then I looked at the VFP help and realized that it does not appear to be supported in vfp 6 or 7. How about in 8?
>>
>>How can I update rows in one table in vfp based upon a join condition on two tables?
>>
>>TIA