Database - 1

What is the most common type of join?

• JOINED TABLE

• INSIDE JOIN

• JOINED

• INNER JOIN

Returns records that have matching values in both tables

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

Returns all records from the right table, and the matched records from the left table

• INNER JOIN

• RIGHT JOIN

• FULL JOIN

• LEFT JOIN

Returns all records from the left table, and the matched records from the right table

• RIGHT JOIN

• FULL JOIN

• INNER JOIN

• LEFT JOIN

Returns all records when there is a match in either left or right table

• LEFT JOIN

• FULL JOIN

• RIGHT LOIN

• INNER JOIN

mark the correct answer

• INNER JOIN

• RIGHT JOIN

• LEFT JOIN

• FULL JOIN

mark the correct answer

• INNER JOIN

• RIGHT JOIN

• LEFT JOIN

• FULL JOIN

mark the correct answer

• LEFT JOIN

• INNER JOIN

• LEFT JOIN

• FULL JOIN