locked
table compare RRS feed

  • Question

  • I am a relatively new user of access. I have 2 tables to compare. One(table 1) having 3923 rows and the other(table 2) having 3290 rows.  I need to know which rows on table one are not on table 2. Following is my latest attempt. Thanks in advance from this novice
    Thursday, February 9, 2012 4:54 PM

Answers

  • pjonas wrote:
    > I am a relatively new user of access. I have 2 tables to compare.
    > One(table 1) having 3923 rows and the other(table 2) having 3290
    > rows.  I need to know which rows on table one are not on table 2.
    > Following is my latest attempt. Thanks in advance from this novice
     
    The built in "Find Unmatched Query Wizard" of Access can help you here.
    It should be proposed in the dialog when you create a new query.
     
    The resulting query will look like this:
     
    SELECT Table1.*
    FROM Table1 LEFT JOIN Table2 ON Table1.Id = Table2.Id
    WHERE Table2.Id Is Null
     
     
    --
    cu
    Karl
    *********
    Access-FAQ (German/Italian): http://www.donkarl.com
     
     
     
    • Proposed as answer by accessbob-pdx Thursday, February 9, 2012 5:22 PM
    • Marked as answer by Bruce Song Thursday, February 23, 2012 9:59 AM
    Thursday, February 9, 2012 5:07 PM
  • Also referred to as a Frustrated Join:

    http://www.utteraccess.com/wiki/index.php/Frustrated_Join

    hth


    Jack D. Leach (Access MVP)
    UtterAccess Wiki: (Articles, Functions, Classes, VB7 API Declarations and more)

    • Marked as answer by Bruce Song Thursday, February 23, 2012 9:59 AM
    Friday, February 10, 2012 1:05 AM
  • Check out the UNMATCHED QUERY WIZARD when you click to create a new query.


    Bob Larson, Access MVP 2008-2010, 2011

    • Marked as answer by Bruce Song Thursday, February 23, 2012 10:00 AM
    Thursday, February 9, 2012 5:03 PM

All replies

  • Check out the UNMATCHED QUERY WIZARD when you click to create a new query.


    Bob Larson, Access MVP 2008-2010, 2011

    • Marked as answer by Bruce Song Thursday, February 23, 2012 10:00 AM
    Thursday, February 9, 2012 5:03 PM
  • pjonas wrote:
    > I am a relatively new user of access. I have 2 tables to compare.
    > One(table 1) having 3923 rows and the other(table 2) having 3290
    > rows.  I need to know which rows on table one are not on table 2.
    > Following is my latest attempt. Thanks in advance from this novice
     
    The built in "Find Unmatched Query Wizard" of Access can help you here.
    It should be proposed in the dialog when you create a new query.
     
    The resulting query will look like this:
     
    SELECT Table1.*
    FROM Table1 LEFT JOIN Table2 ON Table1.Id = Table2.Id
    WHERE Table2.Id Is Null
     
     
    --
    cu
    Karl
    *********
    Access-FAQ (German/Italian): http://www.donkarl.com
     
     
     
    • Proposed as answer by accessbob-pdx Thursday, February 9, 2012 5:22 PM
    • Marked as answer by Bruce Song Thursday, February 23, 2012 9:59 AM
    Thursday, February 9, 2012 5:07 PM
  • Also referred to as a Frustrated Join:

    http://www.utteraccess.com/wiki/index.php/Frustrated_Join

    hth


    Jack D. Leach (Access MVP)
    UtterAccess Wiki: (Articles, Functions, Classes, VB7 API Declarations and more)

    • Marked as answer by Bruce Song Thursday, February 23, 2012 9:59 AM
    Friday, February 10, 2012 1:05 AM