SQL – Joins
Table Of Contents:
- What Are SQL Joins?
- Types Of SQL Joins.
(1) What Are SQL Joins?
- SQL Joins allow us to work on multiple tables by joining them together based on a related column.
- By bringing tables together you can have more information about the item.
(2) Types Of SQL Joins?
(INNER) JOIN
: Returns records that have matching values in both tablesLEFT (OUTER) JOIN
: Returns all records from the left table, and the matched records from the right tableRIGHT (OUTER) JOIN
: Returns all records from the right table, and the matched records from the left tableFULL (OUTER) JOIN
: Returns all records when there is a match in either the left or right table.