I have two tables, Users and Managers. The Users table contains all details of system users, including username. Primary key is UserID. The Managers table consists of two columns only, ManID and UserID.
The ManID in the Managers table is the same as the UserID in the Users Table
How would I link back to the Users table to return the username for the Manager for each user returned in the query?
Any help would be appreciated