I have an external data set.
Column A | Column B |
---|---|
a1 | b1 |
a2 | b2 |
There is a table I want to apply an outer join against.
| Column A | Column B | Column C |
| ——– | ——– | ——–|
| a1 | b2 | c3 |
| a2 | b2 | c4|
I have read access only and cannot create a table in the system. How can I get to a result like this
Column A | Column B | Column C |
---|---|---|
a1 | b1 | NULL |
a2 | b2 | c4 |
I tried doing this with a where statement against the table but for instances with no match the lines are not pulled. I require to maintain the unmatched lines with an NULL indicator.
Milosu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.