Relative Content

Tag Archive for joinfilterwhere-clause

Similar filters behave diferently

We have 2 versions of a table: V1 and V2, V1 being the source of truth. I am in the process of comparing both these versions and trying to make V2 a mirror copy of V1(There is no possibility of deleting all the contents of V2 and copying from V1.)
Now, I found that there are lots of missing rows in V2 for a specific date and I need to pull them from V1 for that date. To find out what rows are available in V1 and missing in V2, I am trying LEFT EXCLUDING JOIN