I have two tables, one has a reference to the other. I want to do the following:

```
UPDATE candidate_skill SET skill_id = skill.id WHERE skill_id = SELECT 

WHERE skill.name = "name" ;

```

Is my syntax correct? How can I do the same with join?