Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Join question

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.  

1 Reply

  • PijushRoy's avatar
    PijushRoy
    Community Champion

    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.