I got a solution
declare @tbl_Products table(ID int, Keywords varchar(10))
insert into @tbl_Products values
(1, '1,2'),
(2, '1,3'),
(3, '1,4'),
(4, '2,4')
declare @tbl_Keywords table(Key_ID int, Keyword varchar(10))
insert into @tbl_Keywords values
(1, 'Keyword1'),
(2, 'Keyword2'),
(3, 'Keyword3'),
(4, 'Keyword4')
select P.ID,
P.Keywords,
stuff((select ', '+K.keyword
from @tbl_Keywords as K
inner join P.XKeywords.nodes('/k') as KX(N)
on KX.N.value('.', 'int') = K.Key_ID
for xml path(''), type).value('.', 'varchar(max)'), 1, 2, '') as keywordCSV
from (
select ID,
Keywords,
cast('<k>'+replace(Keywords, ',', '</k><k>')+'</k>' as xml) as XKeywords
from @tbl_Products
) as P
Thanks All for Reply.