Hi All - I have a table as such below (very very simplified version):
I need it to output each individual account number per line, along with a field indicating if the account number has any instance of AMEX on it ....
How can I achieve this? Thanks!
SELECT ACC_NUMBER, PLAN FROM ACCOUNT_TABLE T1