SQL: Update aus zweiter Liste

[omata]

SQL-Code:

UPDATE access
SET OperatorName = o.OperatorName,
    OperatorSurname = o.OperatorSurname,
    OperatorDesc = o.OperatorDesc
FROM access a
LEFT JOIN operator o
  ON a.OperatorID = o.OperatorID