What is the output of the query,
SELECT * FROM Employee_ksm E INNER JOIN Department D ON E.DepartmentId=D.DepartmentId

Answer:

This query is used when you need to join two tables and get the ouput based on where clause. Suppose you have two tables one for maintaining your Employee details and the other for Departments present in your company.
When you want to know in departments the Employee is present then you can use this query.