Multiple table queries for SQL statements

Internal connection

SELECT * FROM employee INNER JOIN department on employee.dep_id = department.id

Left table record is retained on the basis of the inner join

SELECT * FROM employee left JOIN department on employee.dep_id = department.id

Right join on the basis of internal connection keep right table record

SELECT * FROM employee right JOIN department on employee.dep_id = department.id

Full outer connection

MySQL does not support full join. To achieve this effect, use the following statement:

SELECT * FROM employee left JOIN department on employee.dep_id = department.id Union

SELECT * FROM employee right JOIN department on employee.dep_id = department.id

Multiple table queries for SQL statements