如何使用条件更新一个表与来自单独表的数据

This query may be absolutely ridiculous or maybe I just have one little thing wrong. I'm not quite sure. But basically I'm trying to update a table with data from another table in Access. The columns that are giving me issues are those set to "Yes/No" types and the data I'm trying to update it with are set to "Text" types whose values are strings "Yes" or "No."This query may be absolutely ridiculous or mayb