The modifications made by the UPDATE statement cannot affect more than one of the base tables .... The Microsoft SQL Server ODBC driver and OLE DB Provider for SQL Server ...
technet.microsoft.com