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 

Answer 1

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

This is the best code.

Answer 2

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