>Hi Rich,
>
>It's not clear what you want so I'll take a guess
>

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

>
Hi Sergey,

This query would not return customers that don't have corresponding records in the crsFillRate. You can modify it to be

SELECT  cust.customer, COUNT(*) ;
	FROM crsAllCust cust;
	LEFT	JOIN crsFillRate fr ON cust.customer = fr.custshipm ;
	WHERE fr.custshipm  IS NULL OR EXISTS ( SELECT 1 FROM crsFillRate fr WHERE cust.customer = custshipm AND EMPTY(PartOrders)) ;
	GROUP BY cust.customer

to match the original query. But when why do we need EXISTS ?