Asked by Rachel Hwang on May 06, 2024
Verified
To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.
A) right inner
B) orphan outer
C) select inner
D) right outer
Sales Table
A structured arrangement of sales data in rows and columns that is used to analyze, organize, and track sales transactions over a period.
Customers Table
A structured set of data held in a database or spreadsheet, specifically designed to manage information about customers.
Right Outer Join
A SQL operation that returns all records from the right table and the matched records from the left table, with NULL values in the result where there are no matches.
- Acquire knowledge about the attributes and purposes of an outer join.
Verified Answer
ZK
Zybrea KnightMay 09, 2024
Final Answer :
D
Explanation :
A right outer join returns all the records from the right table (Customers) and matching records from the left table (Sales) where available. In case there are no matching records in the left table, the resulting dataset will have null values for the left table columns. By selecting the null values, we can identify the records that have no related records in the Customers table. Thus, a right outer join is the best option for this requirement.
Learning Objectives
- Acquire knowledge about the attributes and purposes of an outer join.