Join question

[Anonymous]

Hi All, 

I have two tables that i would like to join A and B. 

I would like All from table B and left join table A (meaning those from A that are not present in B) 

I now do it in two steps: 

1. Left join table A 

2. Append table B with A to get final result

Maybe a stupid question but is there a Join that combines step 1 and 2?

I am asking this as i also have many other tables to join and when wondering if the steps could be compressed.  

[PijushRoy]

Hi @Anonymous 

I am not very clear with your question and expected result. Why you need to join 1st and append 2nd
Please share format of Table A and Table B (after removing the sensitive data) and expected result.