Sunday 6 October 2013

15. Write a query to display the sales order IDs of the orders that have been paid through a SuperiorCard.

select salesOrderID from sales.OrderHeader
where CreditCardID in (select CreditCardID
from sales.CreditCard Where CardType='SuperiorCard')

No comments:

Post a Comment