By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table TableA (
id varchar(128),
name varchar(128)
);
insert into TableA values
('10023,2019','Bob'),
('1243','Mary'),
('29853','William');
create table TableB (
company varchar(128),
id int
);
insert into TableB values
('Kroc',10023),
('Espres',2019),
('MarcDonalds', 10023);
6 rows affected
SELECT b.ID, max(name)
FROM TableA a
INNER JOIN TableB b
ON a.id = cast(b.id AS VARCHAR(10)) OR a.id like cast(b.id AS VARCHAR(10)) + ',%'
group by b.ID
| ID | (No column name) |
|---|---|
| 10023 | Bob |