Question: Below are excerpts from two data tables: a customer table on the left and a sales transaction table on the right. Invoices are billed to

Below are excerpts from two data tables: a customer table on the left and a sales transaction table on the right. Invoices are billed to customers on a bimonthly basis. [ Answer the following questions. a. Identify the join that would best show all transactions with customer details and explain how this join works and the unique identifier you would use for the join. b. Identify a join that would show all customer and transaction details and explain how this identifier works and the unique identifier you would use for the join
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
