Hello Experts

I have a problem with update statement

I have two tables

MovieStar , StarsIn

MovieStar - name,address,birthdate,gender,rating
StarsIn - movieTitle,movieyear,starname,role

so I want to update the MovieStar - rating field

If StarsIn.role = 'Support'

Basically MovieStar.name and StarsIn.starname is the name of the actor

So if he act a supporting role the i want to update the rating+1

Any ideas

This was done by me..
But its wrong

update moviestar
set rating = rating+1
where moviestar.name=starsin.starname
and starsin.role = 'Support'

Try this:

UPDATE moviestar m
JOIN starsin s ON m.name = s.starname
SET moviestar.rating = moviestar.rating+1;

and starsin.role = 'Support'