![join - SQL query: Fetch Employee Name (i.e. FirstName space LastName), Department Name, Manager, City, StateProvinceCode, CountryRegionCode - Stack Overflow join - SQL query: Fetch Employee Name (i.e. FirstName space LastName), Department Name, Manager, City, StateProvinceCode, CountryRegionCode - Stack Overflow](https://i.stack.imgur.com/exJ8P.jpg)
join - SQL query: Fetch Employee Name (i.e. FirstName space LastName), Department Name, Manager, City, StateProvinceCode, CountryRegionCode - Stack Overflow
How to write Write a query to display the employee name, salary, department name, job for those employees who works with the same designation as the employee whose name is Martin -
![sql server - SQL query to get the employee name and their manager name from the same table - Stack Overflow sql server - SQL query to get the employee name and their manager name from the same table - Stack Overflow](https://i.stack.imgur.com/hgirI.png)
sql server - SQL query to get the employee name and their manager name from the same table - Stack Overflow
![1X3 Employee Name Tag Badge Pin o magnete inciso Allegato personalizzato Identificazione personalizzata incisa Acquista 3 ricevi 1 gratis - Etsy Italia 1X3 Employee Name Tag Badge Pin o magnete inciso Allegato personalizzato Identificazione personalizzata incisa Acquista 3 ricevi 1 gratis - Etsy Italia](https://i.etsystatic.com/7880213/r/il/28bc85/4313011812/il_570xN.4313011812_mazs.jpg)