>>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.