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 ;
b
You might also like to view...
Directing work-in-process through its various stages of manufacturing is part of the conversion cycle
Indicate whether the statement is true or false
Downward communication is used more frequently than upward communication in most organizations
Indicate whether the statement is true or false
A) To what value can the per bottle profit on red nail polish drop before the solution (product mix) would change?
b) By how much can the per bottle profit on green nail polish increase before the solution (product mix) would change? What will be an ideal response?
Which of the following pairs of documents at a minimum, comprise the pleadings in a
civil case? A) statement of claim and statement of defence B) statement of defence and affidavit C) motion and affidavit D) statement of defence and motion E) statement of claim and judgment