JOIN Flashcards

Front

What is the primary purpose of a SQL JOIN? 

Back

To combine rows from two or more tables 

Front

Which type of JOIN returns all rows from the left table and the matched rows from the right table? 

Back

LEFT JOIN 

Front

What does an INNER JOIN do? 

Back

Returns only the rows with matching values in both tables 

Front

Which JOIN includes all records from both tables, matching where possible? 

Back

FULL JOIN 

Front

In SQL, what is a primary key used for? 

Back

To uniquely identify records in a table 

Front

What is the result of a RIGHT JOIN? 

Back

All rows from the right table plus matching rows from the left table 

Front

When using a LEFT JOIN, what happens to the rows in the left table that do not have a match in the right table? 

Back

They are included with NULL values for the right table's columns 

Front

Which of the following is NOT a type of SQL JOIN? 

Back

MULTI JOIN 

Front

What is the purpose of using JOIN conditions (like ON or USING)? 

Back

To define how tables are related to each other 

Front

Which SQL statement is likely to involve multiple JOINs? 

Back

SELECT statement