Options to compare contents of two tables

Database

Options to compare contents of two tables

Hello,

From your experience, what is the best option for comparing contents of two tables? Both ways!

- full outer join?

- minus applied both ways?

- except?

- not exist applied both ways?

Let's say that we have 2 tables: extract and extract_previous and every day you have to check the diff between them. 

thanks in advance!

2 REPLIES
Fan

Re: Options to compare contents of two tables

In our project we use minus, so i feel its good way.

Re: Options to compare contents of two tables

Thanks Inguva!