Use of SQL INNER JOIN

Use of SQL INNER JOIN. The following command shows how to join common data use SQL INNER JOIN.

 

SELECT table1.*, table2.column, table2.column
FROM table1
INNER JOIN table2
ON table1.column = table2.column;

Example:

SELECT employees.*, payments.date, payments.amount
FROM employees
INNER JOIN payments
ON employees.id = payments.employee_id;