Joining table without duplicating value

[Anuj_1196]

Hi, community

I have 2 tables with a unique ID, where I'm looking to populate a column from another table without duplicating the records.

Table A

ID	Name	Job ID
1	A	1
2	B	1
3	C	2
4	D	3
5	B	3
6	A	2
7	E	4
8	E	8

Table B

Job ID	Job Name
1	ABC
2	CDE
3	DEF
4	EFG
5	FGH
6	GHI
7	HIJ

Desired Output

ID	Name	Job ID	Job Name
1	A	1	ABC
2	B	1	ABC
3	C	2	CDE
4	D	3	DEF
5	B	3	DEF
6	A	2	CDE
7	E	4	EFG
8	E	8

[gawa · Accepted solution]

hi @Anuj_1196 

I understand that you want to have Left Outer Join results. Please see the attached WF.

By using Multiple Join tool ,you can easily obtain all type of JOIN operation(Full Outer join, Left Outer Join, Right Outer join, Inner Join) like this. This is just for your information.

[Qiu · Accepted solution]

@Anuj_1196 
Or we can just use a Join tool then union the L and J data together.