Sunday, 6 October 2013

02. Write a query to display the credit card number of Catherine Abel.

select CaedNumber from sales.creditCard
where creditCardID=(select creditCardID from sales.contactCreditCard where contactID=
(select contactID from Person.Contact where FirstName='Catherine' and LastName='Abe1'))

No comments:

Post a Comment