I have two tables. One table is called Employees and one is called Teams.
In the Employee table I have the following columns (Name, StartDate, Position, TeamID)
In the Teams table I have the following columns (URL, Active, TeamID)
I want to select Name, StartDate, and Position from the Employee table
as well as
URL, and Active from the Teams table
Where the ID is the same
Employee record: Mike Smith | 1/1/1980 | Comptroller | 55
Teams record: www.google.com
| Yes | 55
would display this in the result:
Mike Smith 1/1/1980 Comptroller www.google.com
How do I do this?