Câu 48: E20-007: Data Science and Big Data Analytics

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?

1. A. Full outer join — đáp án hiện tại
2. B. Inner join
3. C. Left outer join
4. D. Cross join