Combining multiple sets of data

[G_SAND]

Hi. As with most things I am sure this is easy!

I have 3 separate sets of data:

Part	Field 1		Part	Field 2		Part	Field 3
A	1		A	4		A	6
B	2		B			B	7
C	3		C	5		C

I want to combine so it reads:

Part	Field 1	Field 2	Field 3
A	1	4	6
B	2		7
C	3	5

I have tried a couple of things but can't seem to get it right.

Any help would be great.

Thanks

[MarqueeCrew · Accepted solution]

JOIN MULTIPLE:

Part = Part = Part

Uncheck all duplicate part fields.

Done :)

[G_SAND · Accepted solution]

Thanks.

I had tried this before and it didn't look right. But I realized it would only work with 1 of the tables as Input 1.