An Easier Way to Use Left Outer Join Using the Join Tool

Question

Hello,

I just noticed that, when trying to implement a "left outer join" on data using the Join tool, I still have to use the Union tool to combine the data from the left (L) and join (J) outputs. Then I have to address those warning messages that some fields from the join are not present in all inputs.

Is there an easier way to do this wherein data for both are actually combined already?

This is not the case when using the Join In-DB tool.

RonGatmaitan · Answer

Thank you, @apathetichell. 🙂

apathetichell · Answer

You can set the Union tool to not give you those messages (Ignore when Fields are different). There is no automatic way to do an Outer Join (Left/Right/Full) with the (conventional) Join tool. You have to combine it with the Union tool.