>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 >>
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.customerto match the original query. But when why do we need EXISTS ?