EMC Exam Questions

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?

A.
Full outer join

B.
Inner join

C.
Left outer join

D.
Cross join