帮忙找个例子的错？

Question

update Employees
set City='Missoula'
where CustomerID='THECR'Employees表中没有CustomerID字段

Answer 1

select *
from Customers
where Region='WA'
and Country='USA'
order by PostalCode ASC,CustomerID ASC;
update Employees
set City='Missoula'
where CustomerID='THECR'

Answer 2

update Employees
set City='Missoula'
where CustomerID='THECR'而Customers中有字段CustomerID你自己都说Customers中有字段CustomerID
而你更新的Employees表，那Employees表里有字段CustomerID吗？？

Answer 3

update Employees
set City='Missoula'
where CustomerID='THECR'在Employees中没有CustomerID欄位