Join All from Left + Matching from right?

[warrencowan]

Hi Everyone,

Im trying to do a join that outputs all the records from the left with the matching records from the right, but the join block only appears to support a right / left exclusive or inner join. Am i missing something, or is a more creative solution required.

Many thnaks in advance

Warren

[jdunkerley79 · Accepted solution]

Yes that is correct the join tool returns just the joins from the J output.

Use a union tool to add the record in the L output to the J output and you should have what you want.

[warrencowan]

I was beginning to suspect that was going to be the answer.

Thanks very much jd for clarifying.