I have two tables where 1st table is Englishgermankwds_tbl and 2nd is Kwd_UploadRecored the data of the tables is as follows
Table Englishgermankwds_tbl
English_Keywords German_Keywords
architecture Architektur
Arrival Ankunft
aspirations Lebensziel
attire Kleidung
Blueprint Technische Zeichnung
Carrying Tragen
caucasian appearance Europäischer Abstammung
cheerful fröhlich
clothes Kleidung
color image Farbbild
day Tag
Development Entwicklung
differential focus Geringe Tiefenschärfe
focus on foreground Fokus auf den Vordergrund
front view Vorderansicht
Full Length Ganzkörperansicht
growth Wachstum
Happiness Glücklichsein,Glück
Hardhat Bauarbeiterhelm
Table Kwd_UploadRecored
ID Primary_Kwd Sec_Kwd Main_Kwd
1 Man,One Man,architecture,Boy Arrival,Sigle Man , Business Man ,Male aspirations,One Person
2 Woman,attire,Girl Girl,Girls,Female,Blueprint,Carrying, Teenage Girl,Only Girls
3 Grand father,Man,caucasian appearance cheerful, Family,Fatherhood,Family Member, Male Parent,
4 Baby ,clothes,color image growth,Babies,Child,Happiness Children,Toddlers,differential focus,
I want to update the all English keywords of Kwd_UploadRecored to German which is matched from the English keywords of Table Englishgermankwds_tbl
I want the expected result like- Kwd_UploadRecored table would be
ID Primary_Kwd Sec_Kwd Main_Kwd
1 Man,One Man,Architektur,Boy Ankunft,Sigle Man , Business Man ,Male Lebensziel,One Person
2 Woman,Kleidung,Girl Girl,Girls,Female,Technische Zeichnung, Teenage Girl,Only Girls
3 Grand father,Man,Europäischer Abstammung fröhlich, Family,Fatherhood,Family Member, Male Parent,
4 Baby ,clothes,Farbbild Wachstum,Babies,Child,Glücklichsein Children,Toddlers,differential focus,
Please help how to achieve this.
Aucun commentaire:
Enregistrer un commentaire