× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
5
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
Shann_5501 Shann_5501
wrote...
Go to Answer
Posts: 634
Rep: 0 0
6 years ago
Based on the code above, list the number and name of all customers that are either represented by sales rep 30 or that currently have orders on file, or both.
 a. SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer ;
  b. SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders WHERE Customer.CustomerNum=Orders.CustomerNum ;
  c. SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' WHERE Customer.CustomerNum=Orders.CustomerNum ;
  d. SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders ;
Read 28 times
1 Reply
Replies
Answer verified by a subject expert
casssmcasssm
wrote...
#1
Top Poster
Posts: 955
Rep: 6 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

Shann_5501 Author
wrote...

6 years ago
Thank you, thank you, thank you!
SlimyPencil
wrote...

Yesterday
You make an excellent tutor!
nicolepope23
wrote...

2 hours ago
Thanks
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1323 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Related Images
  
 48
  
 281
  
 787