Sunday 6 October 2013

04. Write a query to display the first name and the last name of the customers along with their credit card identification number.

select firstName, Lastname, B.CreditCardID
from Person.contact A Cross apply
(select * from sales.contactcreditcard B Where B.contactID=A,contactID)B

No comments:

Post a Comment