SQL INNER QUERY在UPDATE查询中返回多个值

I have a table to be updated using records of another table and I am doing this to bring over information from one system (database) to another. The scenario is bit complex, but I desperately need help I have a table to be updated using records of a