Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Question Unanswered: comparing whole records in two tables

    Anybody got SQL code sample for comparing two tables?

    I need to know if if the records in table B, which some time ago was an identical copy of table A (the original), has been changed, or if the tables/records are still identical (field/record/content comparison, not structure comparison).

    Need to display a list of which records in table B have been changed. (if any)
    Thought I had seen a wizard for this some time ago, but perhaps not.

    Last edited by kedaniel; 08-01-04 at 14:31.
    Win-XP pro, Access 2002, ADO 2.7, DAO 3.6. English versions of apps/OS.

  2. #2
    Join Date
    Jun 2004
    Saratoga Springs
    See attached file for example.

    You could start of by using the 'Find Unmatched Query Wizard'.

    However, it sounds like you need to evaluate change across multiple fields; in which case you would need to create a join between the two tables for each field you want to monitor change for and supply an additional "OR IS NULL" criteria for each field.

    I have done that for 3 fields in the query 't1_copy Without Matching t1'. You could use these same techniques for as many fields as you need.

    Hope this helps
    Attached Files Attached Files
    Jon Jaussi, OCP DBA
    D4L Data Managent Solutions

Posting Permissions

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