Quote Originally Posted by nagelkruid View Post
Ah got it, you aren't allowed to do this via the SQL tool that is build into the admin, or at least that functionality is not build into it.
From the help file: UPDATE (just a single table)

So if you want these queries to run succesful, you will need to execute them directly via dbadmin if you have access to it.
Remember to add your table pre-fix to the 2 tablenames if you run it from there.

Cheers,
Jeroen
ok, hmm. does that mean no hope for me if i don't know how to do that?