• You can join on many tables, that's not a problem. So, you could easily have a query that looks like:
    SELECT E.Name,
           D.Department,
           ISNULL(J.Name, 'No Assigned Role') AS JobRole
    FROM Employee E
        JOIN Department D ON E.DepartmentID = D.DeparmentID
        LEFT JOIN Job J ON E.EmployeeID = J.EmployeeID;

    This would JOIN the Employees table to both the Department and Job tables, however, if no job for an employee is found, it will still return the Employee (as it is a LEFT JOIN).

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk