diff options
Diffstat (limited to 'bin/select-cust-desync_bill_dates.sql')
-rw-r--r-- | bin/select-cust-desync_bill_dates.sql | 9 |
1 files changed, 0 insertions, 9 deletions
diff --git a/bin/select-cust-desync_bill_dates.sql b/bin/select-cust-desync_bill_dates.sql deleted file mode 100644 index 5506f90..0000000 --- a/bin/select-cust-desync_bill_dates.sql +++ /dev/null @@ -1,9 +0,0 @@ -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 - ); |