Inner join

Inner joins are far and away the most common kind of JOIN. They match records together based on one or more common fields, as do most JOINs, but an INNER JOIN returns only the records where there are matches for whatever field(s) you have said are to be used for the JOIN.

select employname 
from employee
inner join managername
on employee.employname=manager.managername

see more plz visit