Comparing 2 like tables

Giganews Newsgroups
Subject: Comparing 2 like tables
Posted by:  turtle (kols…@vistacontrols.com)
Date: 22 Aug 2006

I have 2 tables with the same fields.  I would like to compare the two
tables to get a discrepancy report.  Here is an example of what i would
like to see.  I need to compare TableB to TableA and report the
differences.

TableA

Job#    Date      Amount
1          1/1/06      $15
2          1/10/06    $10
3          1/8/06      $50

TableB

Job#      Date      Amount
1          1/1/06      $15
2          1/10/06    $18
3          1/8/06      $60

I would like the report to say
Job#      Date      Amount
2            1/10/06    $8
3            1/8/06      $10

Is this doable?
thanks,
KO

Replies