Computer Science, asked by Jashanrpr347, 1 year ago

A join between two tables that returns the results of the inner join as well as the unmatched rows from the left (or right) table is called a left (or right) outer join. Mark for review (1) pointstruefalse

Answers

Answered by abhinavprajit

FALSE is the answer to ur qst

Answered by surajnegi0600

Answer:

The statement is true. A join between two tables that returns the results of the inner join as well as the unmatched rows from the left (or right) table is called a left (or right) outer join.

Explanation:

In a left outer join, all the rows from the left table are included in the result set, along with any matching rows from the right table. If there is no match, the result will contain NULL values for all the columns of the right table.

For example, consider two tables, Customers and Orders. A left outer join between these tables would return all customers, along with any orders that they have placed. If a customer has not placed any orders, the result set would still include that customer, with NULL values for the order-related columns.

On the other hand, a right outer join is similar to left outer join, but it returns all rows from the right table, along with any matching rows from the left table. If there is no match, the result will contain NULL values for all the columns of the left table.

Outer joins are useful when you want to include all the rows from one table in the result set, even if there are no matches in the other table. This can be useful when working with data that may not be complete or consistent, or when you want to include information from one table that is not present in the other.