select firstName, Lastname, B.CreditCardID
from Person.contact A Cross apply
(select * from sales.contactcreditcard B Where B.contactID=A,contactID)B
from Person.contact A Cross apply
(select * from sales.contactcreditcard B Where B.contactID=A,contactID)B
No comments:
Post a Comment