Record Update Conundrum

[Trilogen]

I'm trying to update a record although my condition requires going to the parent table for updating the right record.

As you can see it's a lame attempt but I hope it's obvious what I'm trying to achieve:

Can someone show me an example of the appropriate way?

[nemonoman]

UPDATE profile
INNER JOIN login
ON login.id=profile.id
SET profile. lastname='lastname'
WHERE login.username='username'