[Solved] SQL where clause two seperate values? [closed]

You have to join the the employee table twice: select distinct employee.LastName, employee.EmployeeId, manager.Lastname from customer join employee as employee on customer.SupportRepId = employee.EmployeeId join employee as manager on employee.ReportsTo = manager.employeeId where customer.Country = ‘Canada’ 0 solved SQL where clause two seperate values? [closed]