SELECT * ; > FROM Companies Co ; > LEFT OUTER JOIN Sales Sa ; > ON Co.KeyValue = Sa.keyBedra AND ; > Sa.Price > 0 ; > INTO CURSOR GoodResultI 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.