MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Table_A (
  `ID` varchar(1)
);

INSERT INTO Table_A
  (`ID`)
VALUES
  ('1'),
  ('2'),
  ('A'),
  ('B'),
  ('C'),
  ('D'),
  ('E'),
  ('F');

Records: 8  Duplicates: 0  Warnings: 0


CREATE TABLE Table_B (
  `ID` INTEGER,
  `Rel_ID` VARCHAR(1)
);

INSERT INTO Table_B
  (`ID`, `Rel_ID`)
VALUES
  ('1', 'A'),
  ('1', 'B'),
  ('1', 'C'),
  ('1', 'D'),
  ('2', 'E'),
  ('2', 'F');

Records: 6  Duplicates: 0  Warnings: 0


CREATE TABLE Table_C (
  `ID` VARCHAR(1),
  `Type` VARCHAR(11)
);

INSERT INTO Table_C
  (`ID`, `Type`)
VALUES
  ('A', 'Payment_Adv'),
  ('B', 'Payment_Clr'),
  ('c', 'Payment_A'),
  ('D', 'Payment_GP'),
  ('E', 'Payment_Adv'),
  ('F', 'Payment_Clr');

Records: 6  Duplicates: 0  Warnings: 0


SELECT A.id,
       B.Rel_ID,
       C.Type
FROM Table_A A
INNER JOIN Table_B B ON A.ID = B.ID
INNER JOIN Table_C C ON B.Rel_ID = C.ID
WHERE NOT EXISTS    (SELECT 1
     FROM Table_B B1 
      INNER JOIN Table_C C1 ON B1.Rel_ID = C1.ID 
     WHERE B1.ID = A.id
       AND C1.`Type` IN ('Payment_GP'))


id
Rel_ID
Type


2
F
Payment_Clr

2
E
Payment_Adv