SQL Server - inner join when updating - Stack Overflow

I have the below query which does not work. What am I doing wrong? Is this even possible? UPDATE ProductReviews AS R INNER JOIN products AS P ON R.pid = P.id ...

stackoverflow.com