Question

SQL:

Join the 'employees' and the 'dept_manager' tables to return a subset of all the employees whose last name is Markovitch.

Answer 1

Join the 'employees' and the 'dept_manager' tables to return a subset of all the employees whose last name is Markovitch.

SELECT E.EMPLOYEE_ID,E1.FIRST_NAME FROM EMPLOYEES E FULL OUTER JOIN DEPT_MANAGER E1 ON E.LAST_NAME = E1.LAST_NAME WHERE E.LAST_NAME='Markovitch';

The above query will give the output whose Last_name is Markovitch You can use 2 table name which you want to join. In this Query I have taken E as Employee Table E1 as Dept_Manager Table and I have used Full Outer Join to combine Employees and Dept_Manager Table and in where condition I have used 'Markovitch' which will get all the dats whose name is 'Markovitch' from both tables.