>Hi all
>
>I have 2 tables with the same structure and I want to
>Compare if the data in the 2 tables are the, same can anyone give me a quick solution
>thanx all

SELECT * FROM TableOne ;
UNION ;
SELECT * FROM TableTwo

If the tables are identical then the resulting cursor should have the same number of rows as the source tables. If there are differences then the RecCount() will increase. You can subsequently use a CNT() on a (preferably primary key) field that you are confident is the same for rows where other fields may have changed.