如何在T-SQL中正确更新2个表？

I found out the 2 tables are very different in data per row. Now I'm just wondering how they're can properly be updated. I tried to use LIKE or CONTAINS but I don't know how to implement them since the data are strictly different words or data. Hopefully, you can help me. Thank you so much.I found out the 2 tables are very different in