Hi Sergey,

Thanks. Well, I guess my memory isn't too good then! I think I need a memory upgrade for my brain.

>Hi David,
>
>Foxpro never supported such syntax. Until VFP3 foxpro didn't support outer joins at all.
>
>>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.