Question 5 • DRHS-Business and Tech BLOCK (07.4410030)
An inner join returns rows only when a customer record matches an order record through the join condition. Therefore, it includes customers who placed orders and orders that are attached to customers. It excludes orphaned records and customers who did not place orders because those rows have no match in the other table.
AI-written and checked against the verified answer.