PrepAway - Latest Free Exam Questions & Answers

Which type of join would you use for this table?

You have two tables of customers in your database. Customers in cust_table_1 were sent an e-mail promotion last year, and customers in cust_table_2 received a newsletter last year.
Customers can only be entered in once per table. You want to create a table that includes all customers, and any of the communications they received last year. Which type of join would you use for this table?

PrepAway - Latest Free Exam Questions & Answers

A.
Full outer join

B.
Inner join

C.
Left outer join

D.
Cross join


Leave a Reply