WITH code_t AS ( SELECT 1 cd, 'A' nm UNION ALL SELECT 2, 'B' UNION ALL SELECT 3, 'C' UNION ALL SELECT 4, 'D' UNION ALL SELECT 5, 'E' ) , data_t AS ( SELECT 1 id, '1,2,3' cds UNION ALL SELECT 2, '2,5' ) SELECT * FROM data_t a INNER JOIN code_t b ON CHARINDEX(CONCAT(',', b.cd, ','), CONCAT(',', a.cds, ',')) > 0 ;