NSC | JOIN Types: INNER JOIN

An inner join is a type of SQL join that combines rows from two tables based on a shared or common value. It matches and retrieves data where there is an intersection between the specified columns of both tables. As a result, only the rows that satisfy this condition are included in the output.

Sample Query:

The following is an example of an inner join between the "customer" and "employee" tables:

SELECT customer.entityid, customer.email, employee.entityid 
FROM customer 
INNER JOIN employee 
ON customer.salesrep = employee.id;

In this query, the customer table is joined with the employee table based on the common value of customer.salesrep and employee.id.