Join two tables but keep specific fields from both

[hovicke]

Hi - I have two tables that I need to combine by 'Employee ID'. Table A has employee ID as well as some other columns with entitlement information about the employee. Table B has employee ID as well as the employee's supervisor name and ID in separate columns along with a bunch of other random columns without information I care about. How would I join the two tables together to keep all of the information from table A, but just add two columns that match the employee ID from table A to the employee ID from table B and include the supervisor name and ID? 

I don't want to change the number of rows in the output table from the number of rows in Table A (table B is more of a directory that I am using to just pull the employees supervisor info from).

Edited with example table below... the actual files are bigger and more complex, but this is what I'm trying to accomplish...

Table A:

Employee ID	Access	Level
123	group 1	low
456	group 2	medium
789	group 3	high

Table B:

Employee ID	Useless	Supervisor ID	Supervisor Name	Useless	Useless
123	a	321	John	b	c
234	a	432	Brett	b	c
345	a	543	Ryan	b	c
456	a	654	James	b	c
567	a	765	Brenda	b	c
678	a	876	Kate	b	c
789	a	987	Jane	b	c

Output:

Employee ID	Access	Level	Supervisor ID	Supervisor Name
123	group 1	low	321	John
456	group 2	medium	654	James
789	group 3	high	987	Jane

[Yoshiro_Fujimori]

Hi @hovicke ,

Join tool allows you to select fields you want to output.

So you can uncheck the unnecessary fields as below.

I hope this answered to your question.