I have to create a report by combining multiple tables, matching my condition.
Now my problem is, I have to write down the mail id in the report. For a particular customer, we can have multiple mail IDs, say personal mail id, secondary mail id, Customer mail id and few more options.
When 2 or more mail ids are there, i have to chose Primary mail first and if primary is not available, then say secondary and if that is also not available, then Customer mail id.
Mail IDs are in a single column, Mail id code to define primary or sec is another column.
Basically i need to check the Mail_id_code value and based on that write the mail id from other column into report.
I have to create a report by combining multiple tables, matching my condition.
Now my problem is, I have to write down the mail id in the report. For a particular customer, we can have multiple mail IDs, say personal mail id, secondary mail id, Customer mail id and few more options.
When 2 or more mail ids are there, i have to chose Primary mail first and if primary is not available, then say secondary and if that is also not available, then Customer mail id.
Mail IDs are in a single column, Mail id code to define primary or sec is another column.
Basically i need to check the Mail_id_code value and based on that write the mail id from other column into report.
How should i query this now please.
I personally did not understand: who is who, and what is what?
1. Please, try to explain your problem more clearly.
2. Besides of this, please demonstrate what did you try so far by yourself?
3. Do not forget to emphasize all your samples of data, and of code. You have to use the Code button to do this.
Without presenting all 1-2-3 to the forum, there is a very little chance to get any answer.