Question: If these tables are joined by Customer ID using a left outer join, how many rows would be in the resulting query? Left Table Customer

If these tables are joined by Customer ID using a left outer join, how many rows would be in the resulting query?
"Left Table"
Customer ID
Order Date
1004
6/7/2016
1005
5/6/2016
1005
6/10/2016
1005
7/20/2016
1006
5/4/2016
1007
4/2/2016
1007
4/2/2016
1007
4/2/2016
"Right Table"
Customer ID
City
1005
Columbia
1006
Aiken

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!