Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    3

    Unanswered: Comparing two tables

    Hi, i have two queries which both contain a certain field... the contents of both fields should match but there are 980 records in one table and 990 in the other, does anyone know how I can select only the records that do not correspond to each other???

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Comparing two tables

    Originally posted by cobs
    Hi, i have two queries which both contain a certain field... the contents of both fields should match but there are 980 records in one table and 990 in the other, does anyone know how I can select only the records that do not correspond to each other???

    Thanks
    Try running the unmatched query wizard ...

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: Comparing two tables

    Originally posted by cobs
    Hi, i have two queries which both contain a certain field... the contents of both fields should match but there are 980 records in one table and 990 in the other, does anyone know how I can select only the records that do not correspond to each other???

    Thanks
    Try:
    Select Field1, Field2,... From Tab1
    Where Field1 NOT IN (SELECT Field1, field2, .... FROM Tab2)

Posting Permissions

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