Update with Join using Active Record. Is this possible?

[eluser]Unknown[/eluser]
Hi,

I'm trying to run an update query that uses multiple joins in order to identify the affected rows, but I can't seem to get it working using Active Record. I can't find much info online about it either.

Is this even possible?