Explore tens of thousands of sets crafted by our community.
SQL JOIN Clauses
5
Flashcards
0/5
LEFT (OUTER) JOIN
Returns all records from the left table, and the matched records from the right table. If there is no match, the result is NULL on the right side.
INNER JOIN
Combines rows from two or more tables based on a related column between them. Returns rows that have matching values in both tables.
RIGHT (OUTER) JOIN
Returns all records from the right table, and the matched records from the left table. If there is no match, the result is NULL on the left side.
FULL (OUTER) JOIN
Combines LEFT and RIGHT OUTER JOINS. It returns all records when there is a match in either left or right table. Rows that do not have a match in both tables will have NULL values for the columns from the other table.
CROSS JOIN
Returns the Cartesian product of the rows from the tables in the join. In other words, it combines each row from the first table with each row from the second table.
© Hypatia.Tech. 2024 All rights reserved.
