If SalesPerson Table is the left table, and Cash Receipts Table is the right table, which type of join of the two

tables will result in the Answer Table:

A. Left Outer Join

B. Inner Join

C. Right Outer Join

D. None of the Above

Salesperson Table SalespersonID SalespersonName S1 Amy S2 Bill S3 Julia S4 Ella S5 Chris Cash Receipts Table CR# Date CR1 CR2 CR3 CR4 CR5 1/20/2020 1/15/2020 1/18/2020 1/18/2020 1/25/2020 Amount Salesperson# 3250 55 900 S5 1000 500 S2 300 Date Answer Table SalespersonID SalespersonName CR# S2 Bill CR4 S5 Chris CR1 S5 Chris CR2 1/18/2020 1/20/2020 1/15/2020 Amount Salesperson# 500 S2 3250 S5 S5 900