W09 Flashcards
(6 cards)
1
Q
What is the purpose of a SQL join?
A
A SQL join combines data from multiple tables based on a related column, allowing meaningful data retrieval from a normalized database.
2
Q
INNER JOIN
A
Returns rows that have matching values in both tables.
3
Q
LEFT JOIN
A
Returns all rows from the left table, and matched rows from the right table.
4
Q
RIGHT JOIN
A
Returns all rows from the right table, and matching rows from the left table.
5
Q
FULL OUTER JOIN
A
Returns all rows from both tables, even if there is not a related key.
6
Q
A
