Join tool dropping data that doesn't join

[jark1294]

I'm trying to tie together two data sets with a join tool, but it's only keeping the data where the match rules are met. I'm trying to keep all data from the left data set even if there's not a match. Is there a setting to change this? Would unionizing the left output with the joined output be my best route?

[StephenR · Accepted solution]

You are correct.  A union after the join to bring in the left data would perform a Left Join.  The Join output only gives the Inner Join.

[jewelss_04]

I am having this problem too, and using the Union tool did not work.  My issue is that on the Left output, it drops those that don't match, and I am not sure why.  For instance, 1111 is in the left but not the right.  When I do the Join, it completely drops 1111 from everything, and is not in the L output.