On the other hand, if you use the EXISTS operator, all rows are modified because at least one of the itemNumber values exists in the table subquery.

另一方面，如果使用 EXISTS 操作符，则将修改所有行，因为至少有一个 itemNumber 值存在于表子查询中。

youdao

An inner join is essentially the intersection of two tables, where the tables are matched by comparing the values of a key column, such as itemNumber.

内连接实际上是两个表的交集，它通过比较关键列(比如itemnumber)的值来匹配表。

youdao