I have 2 identical DBs, one of the tables has C1, C2, C3 , composite key. I'm trying to get the rows from B that are not present in DB A.
I have tried many approaches, but at this time I even can't re-use this suggestion due too the late hour.
I think it should be by something like
Select * from B where not exists (SELECT a.C1, a.C2, a.C3 from A.table as a, b.table as b where a.C1=b.C1 , a.C2=b.C2 , a.C3=b.C3)
But I know that I'm totally wrong. What is the proper way to do this?