Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    8

    Question Unanswered: Compaing two tables to see differences

    Hello,
    I have a simple address collection database which contains two tables "A" and "B"
    "A" table was made by my friend who put his addresses collection and "B" was done by myself
    Both have the same columns (name,family name,telephone,address) - as we agree the same format before filling with the data.
    Some records (raws) are identical in both tables (because we have common friends) but some are different.

    I have no clue how to create a third table (or whatever) which contains raws which are in "A" table but not in "B" table
    In another words-I'd like to create something what shows differences


    So let's say the first table "A" contains records:

    John Smith Switzerland 4322342
    Paul Hammond USA 3453453
    Mary Watson England 98989345

    and "B" table containc raws:
    John Smith Switzerland 4322342
    Mary Watson England 98989345
    Paul McCartney England 3247723

    it should generate:
    Paul Hammond USA 3453453

    As you see I am a newbie in Access
    Huge thanx for the help

    Ber

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    have you tried the find unmatched query wizard
    from your list id probably search on telephone number

    to join your tables together look into the UNION operator in SQL

    Good Luck
    Dave

  3. #3
    Join Date
    Apr 2004
    Posts
    8
    Oh boy
    Right!
    It was so easy to solve my problem
    Great thanx mate for it

Posting Permissions

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