Active Record - Update - Alias and joined Tables

[eluser]The Wizard[/eluser]
Hello friends

ive a quick question. i use this query to copy a row from a table, to another.

the query is:

Code:

UPDATE
    c88v2_user_settings as toSettings,
    c88v2_user_status as fromSettings
SET
    toSettings.settings_staff = fromSettings.rights_staff
WHERE
    ( toSettings.id = 8000 )
    AND
    ( fromSettings.id = 4 )

how could i do exactly this, in active query.

[eluser]Jon L[/eluser]
iirc, active record currently does not support join tables for insert/update queries.

[eluser]The Wizard[/eluser]
thanks

[eluser]The Wizard[/eluser]
on a second thought, this seems unneccessary either

still thanks a lot