before and after [message #21146] |
Tue, 16 July 2002 02:43 |
a
Messages: 22 Registered: March 2002
|
Junior Member |
|
|
Can anyone help me please? I am in a bind..
I have two tables, one table T1 is an original table and the other table T2 is a copy of the first table. Som records in T2 have been deleted, added, or some of the values have been changed. There is 4 unique keys per record that would determine if anything out of the record has been changed.
How would I find out if the entire record has been deleted within T2?
How would I find out if an entire record has been added within T2?
How would I find out if any field within a record in T2 has been changed?
I am using the default Access program for SQL.
TIA!!
|
|
|
Re: before and after [message #21159 is a reply to message #21146] |
Tue, 16 July 2002 11:23 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
-- rows in t1 but not t2
select * from t1
minus
select * from t2;
-- rows in t2 but not in t1
select * from t2
minus
select * from t1;
These queries will also identify any rows that have changed.
|
|
|