hi all
i have 2 tables and with same columns but one column extra in TABLE 2

i am checking / comparing the data in TABLE1 and TABLE 2 are same or not. if any record or column value is different i need to populate that record. in table 1 around 5000 records and in table 2 8000 records existing.

i tried like this


select t1.col1,t1.col2,t1.col3 from table1 t1,table2 t2 where t1.col2 <> t2.col2 and t1.col3 <> t2.col3

i am getting different results when i am executing the above SQL statement.

i am not getting correct results and it's also very slow.

how to compare the 2 tables.


thanks in advnace.


Bernad.