how to get the output using inner join query

Question

Employee table as follows

Empid Empname Deptid

1 Raj 1
2 Ram 2
3 Suresh Null
4 Sam 3
5 Vignesh 2

Department table as follows

Deptid Deptname

1 HR
2 Accounts
3 Sales

i want to get output using inner join Empname and Deptid using above two tables Employee and department table

Nazmul Badsha · Answer

SELECT EmpidEmpnameDeptname FROM Employee INNER JOIN Department ON Department.Deptid = Employee.Deptid This is the best code.

Tapan Patel · Answer

SELECT Empid Empname Deptname FROM Employee INNER JOIN Department ON Department.Deptid = Employee.Deptid