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 |
