MySQL Forums

I have two tables, visualized here:
http://img690.imageshack.us/img690/6422/117200942805am.png

I need to update all the (TableA.ToUpdate) fields to 1 where (TableA.owner) matches the (TableB.ID)s where (TableB.CheckThis)>50

I guess I can do it as follows:
Select id from TableB where CheckThis>50
(PHP loop...
Update TableA set ToUpdate=1 where owner=(ID from loop)
...)

But I was wondering if there was a way I could do this with just a single SQL query.