Use of SQL INNER JOIN
Author: Al-mamun Sarkar
Date: 2020-04-15 18:10:49
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;