Find Missing Customers



--DROP TABLE MCHN..PCT_MISSING_CUSTOMERS

--SELECT A.CUSTNMBR AS MCHN_CUST, B.CUSTNMBR AS OLD_CUST, B.CUSTNAME INTO MCHN..PCT_MISSING_CUSTOMERS
--FROM MCHN..RM00101 A RIGHT JOIN [9-30-14]..RM00101 B ON A.CUSTNMBR = B.CUSTNMBR


--select * from RM00101 where CUSTNMBR = 'RYERSO5776'

--select * from PCT_MISSING_CUSTOMERS

--DELETE MCHN..PCT_MISSING_CUSTOMERS
--WHERE MCHN_CUST IS NOT NULL

Leave a Reply