Hi All,
I need to populate a table C which should show the difference between
two tables A and B. The tables A and B will be populated at different time
intervals. There will be a flag in the Table 'C' which will indicate
whether the record in C is the result of either 'Addition' or 'Deletion'
or 'Modification'.
In case of 'Addition' the records exist in B and not in A. In case of
'Deletion' the records exist in A and not in B. In case of 'Modification'
the record exists in both the tables but there will be difference in
Price.
The table 'C' should have 'PriceMin' and 'PriceMax' column.
We will be comparing the tables based on a column which can
contain duplicates or triplicates. This column will not allow nulls
and is not unique.
Please give me an idea about how to proceed. Your quick response
is highly appreciated.

Thank's alot.
John.