There is a scenario – CID | email | mobile, Now a file is provided from 3rd party containing email and mobile in same column – “email mob” the rows will either contain mobile or email of customers. How do I know which customers have record in the base table? For one customer it may be possible that either email, or phone or both email and mobile are mentioned.
