Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Europe
    Posts
    369

    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.

    Daniel
    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
    Location
    Saratoga Springs
    Posts
    24
    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
    D4L_solutions@comcast.net

Posting Permissions

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