When you use correlated subqueries, always qualify all column names to avoid errors: UPDATE Personnel SET TrID = (SELECT tp.personID FROM [*******].dbo.
確定! 回上一頁