All Forums Database
blue_eyed_byte 2 posts Joined 07/15
09 Aug 2016
Options to compare contents of two tables

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!

Inguva 4 posts Joined 08/16
10 Aug 2016

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

blue_eyed_byte 2 posts Joined 07/15
10 Aug 2016

Thanks Inguva!

You must sign in to leave a comment.