Subject sql query: firebird VS mysql
Author Datatal AB - Gauffin, Jonas
Hello

I'm developing an application that should support both firebird and
mysql.
But since mysql doesnt support subselects i'm using joins.

Do this work in firebird:

UPDATE vm_mailbox box, usr_extension ext
SET user_rights = user_rights ^ 2
WHERE ext.mailbox_id=box.mailbox_id
AND ext.user_id=3