JOIN or INNER JOIN in SQL Server

Question

Accepted Answer

Figure:  

 Figure:  

JOIN or INNER JOINWrite a query, to retrieve Name, Gender, Salary and DepartmentName from Employees and Departments table. The output of the query should be as shown below.
 Figure:  

Code: 


SELECT Name, Gender, Salary, DepartmentName
FROM tblEmployee
INNER JOIN tblDepartment
ON tblEmployee.DepartmentId = tblDepartment.Id



OR


SELECT Name, Gender, Salary, DepartmentName
FROM tblEmployee
JOIN tblDepartment
ON tblEmployee.DepartmentId = tblDepartment.Id



Note:

JOIN or INNER JOIN in SQL Server

Answer with Explanation

Code:

OR