how to find non-matching records in two tables?
Hello all,
I have two tables with the same structure and want to find non-matching records between them. I've tried the bellow sql statement but it run slowly.
select *
from A
where (col1,col2,..) not in
(select col1,col2,... from
Could you please advice some helpful solutions for this situation?