Which of the following SQL statements will list the name of each customer stored in the customers table, and, if the customer has placed an order that is contained in the ORDERS table, the order# of any order each customer has placed?
a. SELECT lastname, firstname, order#FROM orders RIGHT OUTER JOIN customersUSING (customer#);
b. SELECT lastname, firstname, order#FROM orders LEFT OUTER JOIN customersUSING (customer#);
c. SELECT lastname, firstname, order#FROM orders FULL OUTER JOIN customersUSING (customer#);
d. both a and c
d
You might also like to view...
When the equity method is used to account for a long-term investment in the stock of another company, the carrying value of the investment is affected by
A) declines in the market value of the stock. B) the earnings and dividends of the investee. C) an excess of market price over cost. D) neither the earnings nor the dividends of the investee.
A restraint of trade in which two or more competitors at one level of distribution agree not to deal with others at another level of distribution is known as ________
A) group boycott B) resale price maintenance C) price fixing D) market sharing
The ______ structure of integrating international activity makes it possible for foreign subsidiaries in the same country to have a different relationship to the firm depending on the product line.
A. matrix B. international division C. functional division D. product division
When planning a meeting, invite only those who have a specific reason to attend
Indicate whether the statement is true or false