select c.Customer_Number,c.Customer_Name,ws.* from WS_Account ws inner join AR_Customer c on c.Customer_Id =ws.Customer_Id where Account_Name ='the_email.com'
That's what identifies the Customer Number, got that one removed from the cancelled customer to the new customer, was able to register their account.
