MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tablea
    (`Title Name` varchar(5), `ID` varchar(4), `Region` varchar(3), `Numeric Column` numeric)
;
INSERT INTO tablea
    (`Title Name`, `ID`, `Region`, `Numeric Column`)
VALUES
    ('Sam', 'B021', 'NA', 5.99),
    ('Brook', 'B026', 'EU', 5.99),
    ('Harry', 'B032', 'KOR', 10.99)
;


CREATE TABLE tableb
    (`SAM` varchar(4), `BROOK` varchar(4), `HARRY` varchar(4))
;
    
INSERT INTO tableb
    (`SAM`, `BROOK`, `HARRY`)
VALUES
    ('B021', 'B024', 'B030'),
    ('1', 'B025', 'B031'),
    ('2', '4', NULL),
    ('3', NULL, NULL)
;;
SELECT * FROM tablea Where `ID` NOT IN (SELECT HARRY FROM tableb)
OR `ID` NOT IN ( SELECT SAM FROM tableb ) 
OR `ID` NOT IN (SELECT HARRY FROM tableb)



Title Name
ID
Region
Numeric Column


Brook
B026
EU
6

Harry
B032
KOR
11


SELECT SAM FROM tableb 
                                      UNION SELECT BROOK FROM tableb 
                                      UNION SELECT HARRY FROM tableb


SAM


B021

1

2

3

B024

B025

4

null

B030

B031