Good afternoon team,
hope all is well
I am hoping you can help me.
I have following two tables "GODS.DQ_TOBE" & "GODS.DQ_CURRENT". Within each table there is a common column called "Account_code__C". What i would like to do is build a column called Account_code__C which houses the distinct account codes from both of these tables. i would then like to produce two other columns to tell me what table the Account_code__C was found in.
Desired outcome would look something like this
SELECT Account_code__C FROM GODS.DQ_TOBE Select Account_code__C from GODS.DQ_CURRENT