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 anewsletter 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