I have a three tables:
Employee table (empId, firstname, lastname)
Positions table (positionId, title)--{lists positions}
EmpPositions table (empId, empPositionId, positionId)
Not all employee have positions (i.e. not all employees have records in the empPositions table).
Some employee's...