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

by


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]