You have two database tables, an orders table (left) and a customer metadata table (right). You would
Fantastic news! We've Found the answer you've been seeking!
Question:
You have two database tables, an orders table (left) and a customer metadata table (right).
You would like to aggregate the count of orders by gender. To achieve this, you propose to complete a database join.
Which type of join would keep all of the orders, append the gender information where available, but not lose the order data if the customer doesn't have a gender record in the customer metadata table?
a) Left Join
b) Inner Join
c) Outer Join
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: