[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.