That's not valid SQL. The join would be in a FROM clause after the SET arguments. See your DB brand's docs.
1 Like
Sorry, I should have mentioned this query was for MySQL. As @pturmel mentioned, you will need to reformat it to match your particular DB brand.