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

No.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com