You have two tables of customers in your database. Customers in cust_table_1 were sent an email 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?
A.
Full outer join
B.
Inner join
C.
Left outer join
D.
Cross join