>>>>Please Note: VFP 8
>>>>
>>>
>>>PS: Both queries should return wrong count but I don't know what you really want to count (couldn't visualize).
>>>
>>>Maybe this one:
>>>

SELECT  cust.customer, COUNT(fr.custshipm) ;
>>>   FROM crsAllCust cust;
>>>      LEFT JOIN crsFillRate fr ON cust.customer = fr.custshipm AND EMPTY(fr.PartOrders);
>>>   GROUP BY cust.customer

>>>
>>>Cetin
>>
>>The original query actually had COUNT(fr.custshipm). I tested with COUNT(*) and got the same results. And that was the code I cut and pasted. I also tried it with COUNT(*) and COUNT(fr.custshipm) and both fields had the same values.
>
>I think it was a coincidence having the same results. Count(*) should return 1 for no match on right side and that is not right. Count(fr.custshipm) should be the right SQL.
>Cetin

Thanks.

I'll make sure to put back the original code.