Asked by Tanya Koretska on Jun 08, 2024
Verified
To select records from the Customers table that have no related records in the Sales table, create a(n) _____ join.
A) inner
B) outer
C) self
D) referential
Customers Table
A structured data representation in databases specifically designed to store customer-related information.
Sales Table
A structured summary of sales transactions, typically including data on products, quantities, prices, and dates.
Records
A collection of related pieces of information stored in a structured format, often in a database.
- Absorb information regarding the properties and uses of an outer join.
Verified Answer
TH
Tinesha HayesJun 11, 2024
Final Answer :
B
Explanation :
An outer join will include all records from the Customers table, even if there are no matching records in the Sales table. This is because an outer join returns all records from at least one of the tables being joined. An inner join, on the other hand, only returns records where there is a match in both tables. A self join is used when a table needs to be joined with itself, and a referential join is not a valid type of join.
Learning Objectives
- Absorb information regarding the properties and uses of an outer join.