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.
Click Here to Expand Forum to Full Width