oracle10g - Sql Query to print ename and dname please share me how to write query in oracle or Mysql -

employee
eid ename salary
1 charles 3000
2 kiran 2000
3 naveen 8000
4 manju 7000

department

deptid dname
101 charles
102 kiran
103 naveen
104 manju

register

deptid eid

101 1
102 2
103 3
104 4

write query print (employee) ename , (department)dname.

select a.ename, b.depart, c.eid  employee inner join department b on a.ename=b.dname inner join register c on b.deptid=c.deptid a.ename=b.dname , b.deptid=c.deptid;