try this
select
Employee.ID,Employee.Ecode,
Manager.Mcode,
EmployeeName.ID,EmployeeName.Ename
from Manager inner join Employee on Manager.Mcode=Employee.Ecode
inner join EmployeeName on Employee.ID=EmployeeName.ID
where Employee.ID NOT IN (1,2,3,4,5,6,7,8,9);