By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tabA(ID, Account , Amount, Site_Number)
AS
SELECT 1,111111, 200, 14 FROM dual UNION ALL
SELECT 2,111111,-200, 14 FROM dual UNION ALL
SELECT 3,111111, 400, 15 FROM dual UNION ALL
SELECT 4,111111, -400, 15 FROM dual;
4 rows affected
CREATE TABLE tabB(ID, Account , Amount, Site_Number)
AS
SELECT 1, 111111, 201, 14 FROM dual UNION ALL
SELECT 2,111111,-200, 14 FROM dual UNION ALL
SELECT 3,111111, 400, 15 FROM dual UNION ALL
SELECT 4,111111, -400, 15 FROM dual;
4 rows affected
SELECT *
FROM tabA a
FULL JOIN tabB b
ON a.id = b.id -- here should be PK or UNIQUE col
WHERE NOT EXISTS (SELECT a.Account, a.Amount, a.Site_Number FROM dual
INTERSECT
SELECT b.Account, b.Amount, b.Site_Number FROM dual);
| ID | ACCOUNT | AMOUNT | SITE_NUMBER | ID | ACCOUNT | AMOUNT | SITE_NUMBER |
|---|---|---|---|---|---|---|---|
| 1 | 111111 | 200 | 14 | 1 | 111111 | 201 | 14 |