ms access - SQL Updating from an inner join - Stack Overflow

Assuming that the sub-query returns more than one value, you need a second key to connect (JOIN) between the new values and the table you want ...

www.google.com.tw