I have this tables
Table: Contact
IdContact
First Name
Second Name
… other columns
Table: Employee
IdEmployee
IdContact, related to Contact table
… other columns
Table: Salesman
IdSaleman
IdEmployee, if salesman is employee, related to Employee table
IdContact, if salesman is not an employee, related to Contact table
I need a query
Id Salesman - Second name - First name
But I can't figure how to do it, can someone can give advise?
Thanks