Forum Discussion
Conditional column selecting column from other table
Hello all. I need a help. I have two tables: Table A with customer by entity name Table B with customer by entity name and short name How can I add a conditional column in Table A selectin...
Anonymous
Got it! So you can merge the tables with a LEFT JOIN. Then you can create a new conditional column with the format:
IF [new column] = null THEN output=Column1, ELSE [new column]
]