MS SQL Server Joins Interview Question:

What is inner join? Explain with an example?

Submitted by: Administrator

INNER JOIN: Inner join returns rows when there is at least one match in both tables.

Syntax:

SELECT column_name(s) FROM table_name1 INNER JOIN table_name2 ON table_name1.column_name=table_name2.column_name

Example: To display records of an employee who got an appraisal.

SELECT employee.firstname, appraisal.amount FROM employee INNER JOIN appraisal ON employee.id = appraisal.employee.id;
Submitted by: Administrator