compare all the records of all the fields of two tables 
Author Message
 compare all the records of all the fields of two tables

Does some exist it sorts things out of to compare all the records of all the
fields of two tables and to see that this different one among the tables?

Each table has 90 fields

example

table 1                           table 2                table1
table2
field1=a                        field1 = b            field2=5      field2=6
field1=u                        field1=k              field2=9      field2=8
                                                              field2=10
field2=50



Mon, 27 Mar 2006 03:25:44 GMT
 compare all the records of all the fields of two tables

you can use checksum() to work it out.

for example:

select t1.key from
(select key,checksum(*) as chk from table1) t1,
(select key,checksum(*) as chk from table2) t2
where t1.key=t2.key and t1.chk<>t2.chk



Mon, 27 Mar 2006 06:01:30 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. DAO code to compare two fields in two tables

2. Selecting unequal fields from two records in two tables based on PK being equal

3. Compare fields in two tables..

4. Key field violation when comparing two tables

5. SQL Question - Comparing identical (hopefully) key fields in two tables

6. SQL Question - Comparing identical (hopefully) key fields in two tables

7. Comparing two columns in two tables

8. Help..join on two table , Selecting records from two tables

9. recordset should show two fields from two tables, tables have nothing in common

10. Comparing two tables and appending data to destination table

11. Comparing table contents of two tables

12. Retreiving records with the same value from two different table fields


 
Powered by phpBB® Forum Software