Compare tables

[hmfa]

Hi @Tharuprabha

Maybe this thread can help you.

Compare two tables and get the row where values are different

I have two tables. Table 1 (Col1 is primary key): Col1 Col2 Col3 a a a b b a c b b Table 2 (Col1 is primary key): Col1 Col2 Col3 a b b b b a c a a Resultant Table: Col1 Col2 Col3 a a a c a a The row must be compared with respect to primary key and if there are different values in the respective column then filter out the rows. How can I achieve this?

Br