CREATE TABLE IF NOT EXISTS test.tabl1_1
(
    id    INTEGER NOT NULL PRIMARY KEY,
    summa INTEGER NOT NULL
);
INSERT INTO test.tabl1_1
VALUES (1, 100),
       (2, 200),
       (3, 300),
       (5, 500),
       (6, 600),
       (8, 800),
       (10, 1000);
CREATE TABLE IF NOT EXISTS test.tabl1_2
(
    id    INTEGER NOT NULL PRIMARY KEY,
    summa INTEGER NOT NULL
);
INSERT INTO test.tabl1_2
VALUES (1, 100),
       (2, 250),
       (3, 300),
       (4, 400),
       (6, 600),
       (9, 900),
       (10, 1100);

SELECT t1.id as id1, t1.summa summa1, t2.summa summa2, 'identical' as operation
FROM test.tabl1_1 as t1
         LEFT JOIN test.tabl1_2 as t2 ON t1.id = t2.id AND t1.summa = t2.summa
WHERE t2.id IS NOT NULL
UNION
SELECT t1.id, t1.summa,t2.summa, 'deleted'
FROM test.tabl1_1 as t1
         LEFT JOIN test.tabl1_2 as t2 ON t1.id = t2.id
WHERE t2.id IS NULL
UNION
SELECT t1.id, t1.summa,t2.summa, 'changed'
FROM test.tabl1_1 as t1
         LEFT JOIN test.tabl1_2 as t2 ON t1.id = t2.id AND t1.summa != t2.summa
WHERE t2.id IS NOT NULL
UNION
SELECT t2.id, t2.summa,t2.summa, 'new'
FROM test.tabl1_1 as t1
         RIGHT JOIN test.tabl1_2 as t2 ON t1.id = t2.id
WHERE t1.id IS NULL
ORDER BY id1;