Forum Discussion
How to compare data fields with in customer tablle
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer c where Active='Y' -- About 1.5 Million Records Here in this...
Please let me know if I need to provide any more information from myend.
buzza1234 , your post is hard to read, I can't see where code ends and a may exististing question starts. For code please use the code block.
Can you please help here olafhelper. Thank you
so when ever the phones matches (any customers any phone nos ) then assign one generic no.
if email 1 or email 2 matches with any other customer group. but for addr1 and city both has to match with other customer.
Thank you
so when ever the phones matches (any customers any phone nos ) then assign one generic no.
if email 1 or email 2 matches with any other customer group. but for addr1 and city both has to match with other customer.
Thank you