Update matching keywords from first table to second table in SQL
Refer the below solution for the Primary Keyword. 

create table Kwd_UploadRecored(ID int, Primary_Kwd varchar(200),Sec_Kwd varchar(200))
insert into Kwd_UploadRecored values
(1,'Man,One Man,architecture,Boy','Arrival,Sigle Man , Business Man ,Male'),
(2,'Woman,attire,Girl','Girl,Girls,Female,Blueprint,Carrying,'),
(3,'Grand father,Man,caucasian appearance','cheerful, Family,Fatherhood,Family Member,'),
(4,'Baby ,clothes,color image','growth,Babies,Child,Happiness')



create table Englishgermankwds_tbl([English Keywords] varchar(50), [German Keywords] varchar(50))
insert into Englishgermankwds_tbl values
('architecture','Architektur'),
('Arrival','Ankunft'),
('clothes','Kleidung')


Query

;WITH ctePrimary AS (
    SELECT ID,CAST('&lt;t&gt;' + REPLACE(Primary_Kwd, ',', '&lt;/t&gt;&lt;t&gt;') + '&lt;/t&gt;' AS XML) AS p
    FROM Kwd_UploadRecored
), ctePrimary1 AS (
    SELECT ID, x.value('.','VARCHAR(20)') AS Primary_Kwd
    FROM ctePrimary CROSS APPLY p.nodes('//t') a(x)
), ctePrimary2 AS ( --get German keyword if exist else English/Primary keyword
    SELECT A.ID,CASE 
    WHEN B.[German Keywords] IS NULL THEN A.Primary_Kwd ELSE B.[German Keywords] 
    END [German Keywords] 
    FROM ctePrimary1 A LEFT OUTER JOIN Englishgermankwds_tbl B ON A.Primary_Kwd=B.[English Keywords]
), ctePrimaryGroup AS (
    SELECT ID, 
       Stuff((SELECT ',' + [German Keywords] 
              FROM   ctePrimary2 
              WHERE  ID = a.ID 
              FOR xml path('')), 1, 1, '') [German Keywords]
    FROM   ctePrimary2 a 
    GROUP  BY  ID

)
Update Kwd_UploadRecored set Primary_Kwd = [German Keywords]
from Kwd_UploadRecored a inner join ctePrimaryGroup b on a.id=b.id