>Try:
>

SELECT * ;
>   FROM Companies Co ;
>   LEFT OUTER JOIN Sales Sa ;
>      ON Co.KeyValue = Sa.keyBedra AND ;
>         Sa.Price > 0 ;
>   INTO CURSOR GoodResult

I didn't know you could have something like Sa.Price > 0 in the JOIN expression. I thought those expressions had to be field relop field. But I just tried it on some of my data and it worked. Does standard ANSI SQL allow that, or is it a vfp thing? Interesting. Thanks.