I have two tables which are linked to external excel sheets. One table includes employee name and client ID. the other table includes client ID and client performance data.
I want to run a query that assigns the appropriate employee to all of their corresponding client performance data via client ID.
Any help much appreciated.
Thanks.