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.
11-14-2001, 03:47 PM
select t1.col1,t1.col2,t1.col3 from table1 t1
where not existsts
(select null from table2 t2
where t2.col1 = t1.col1 and t2.col2=t1.col2 and t2.col3 = t1.col3);
This will list all the rows from table1 where no rows with the same values in col1, col2 and col3 exist in table2.
02-22-2002, 06:50 AM
How do you deal with NULLS in the where clause?
I've tried nvl on both side but it won't work