Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Smart Sexy Auditing Clerk

Authors: Funny Career Quotes

1st Edition

B08RRJ97CP, 979-8588903189

More Books

Students also viewed these Accounting questions