Question

If you want to join all of the rows in the first table of a select statement with the just matched rows in a second table, you use what kind of join?

a. right outer
b. full outer
c. cross
d. left outer

Answer 1

The correct option is the left outer join.

The correct option to join all of the rows in the first table with just the matched rows in a second table is the left outer join.

In a left outer join, all rows from the first table are included in the result set, along with any matching rows from the second table. If there are no matching rows in the second table, NULL values are used for the columns of the second table.

For example, if you have a table called 'customers' and a table called 'orders,' and you want to retrieve all customers and their corresponding orders (if any), you would use a left outer join.