Error in "UPDATE ... JOIN" statement

https://www.mysqltutorial.org/mysql-update-join/

```sql
UPDATE T1
JOIN T2
ON T1.t2_id = T2.id
SET T1.name = T2.name
WHERE (... some conditions ...);
```

```
sql:Error:Expected ".", "SET", or [ \t\n\r] but "J" found.
```