Write a query to fetch common records between two tables using MySQL?

1.	Write a query to fetch common records between two tables using MySQL?
Answer» USING INTERSECT SELECT * FROM EmployeeSalary INTERSECT SELECT * FROM ManagerSalary

Answer» USING INTERSECT

SELECT * FROM EmployeeSalary
INTERSECT
SELECT * FROM ManagerSalary

Discussion