Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    1

    Unanswered: customers in 2003, not 2004

    I have 2 tables showing customers from 2003 and 2004.
    They show customer number, customer name, and date attended.
    I need to show what customers came in 2003, but not in 2004 by name. Problem with the customer number is that some times the customers lose their cards and get new numbers.

    Any help is appreciated.
    Last edited by Quan22; 01-26-05 at 14:02.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    You will still have difference if also the name changed!
    But you could try:
    Code:
    SELECT NAME FROM TAB2003
    MINUS
    SELECT NAME FROM TAB2004;
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •