select creditCardID, cardnumber, ExpYear
from sales.creditcard Expcept (select creditcardID,cardNumber,Expyear
from sales.creditcard
where Expyear=2005 or Expyear=2007)
from sales.creditcard Expcept (select creditcardID,cardNumber,Expyear
from sales.creditcard
where Expyear=2005 or Expyear=2007)
No comments:
Post a Comment