I have a query which has two select statements having different columns.
Example:
SELECT STATE, COUNTRY FROM MYCOUNTRY
SELECT COUNTRY, CURRENCY FROM MYCOUNTRY
EXPECTED OUTPUT IN EMAIL:
STATE COUNTRY
CA USA
London UK
COUNTRY CURRENCY
USA DOLLAR
UK POUND
I am not sure how to get this kind of output. I have over simplified it but each select statements which I have are completely unrelated and cannot be merged in any way. USERS do not want multiple emails and want data in one email output.
... View more