join

A JOIN clause is used to combine rows from two or more tables, based on a related column between them. There are four types of join in MySQL: INNER JOIN: Returns records that have matching values in both tables LEFT JOIN: Returns all records from the left table, and the matched records Read more…