How Can I Match If Two Tables Columns Are Not Match

See more:

SQL

Here i am using two table namely EMPLOYEE(ID,ECODE,DEPT) and DEPARTMENT(ID, DEPARTMENTNAME),
My table

Employee Department

ID Ecode Dept ID deptName
1 10 1 1 Admin
2 20 2 2 prodn
3 30 3 3 Accounts
4 40 5
5 50 3
6 60 3
7 70 4
8 80 5
9 90 6
10 100 2


here i want to match DEPARTMENT(ID) with EMPLOYEE (DEPT)......
how can i do it

Thanks for Advice and spend your gloden time for me