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.

[Kaish]

I want no additional data from the right table, only what is matching should fill in the values suppose left table has 100 values and right table has 150 records,

here I want only 100 data from the left table and the missing values should be filled in the output which comes from the right table, how can we achieve this ?