bin/select-cust-desync_bill_dates.sql


1
2
3
4
5
6
7
8
9

SELECT DISTINCT custnum, agent_custid, first, last, company
 FROM cust_pkg LEFT JOIN cust_main USING ( custnum )
 WHERE cancel IS NULL AND 0 < (
   SELECT COUNT(*) FROM cust_pkg AS others
    WHERE cust_pkg.custnum = others.custnum
      AND cust_pkg.pkgnum != others.pkgnum
      AND cust_pkg.bill != others.bill
      AND others.cancel IS NULL
 );