JOIN is used to combine rows from multiple tables. There are inner join, left join, right join, full join. Inner join returns rows that match in both tables, left join returns all the value from left table and matched rows from right table; right join vice versa. Full join returns the rows that match in at least ONE table.