Sunday 6 October 2013

12. Write a query to display the contact ID of the customers that have the 'Vista' credit card.

select ContactID,CardType
from sales.ContactCreditCard
join sales.CreditCard no ContactCreditCardID=
CreditCard.CreditcardID
where CardType='Vista'

No comments:

Post a Comment