From your code it looks to me like you're updating one table based on values in
another table, rather than updating two tables at the same time.

This being the case, I'd use a join update.

Quoting Daniel Jimenez <d.jimenez@...>:

>
>
>
>
>
> Hi,
>
>
>
> Is this legal in FB? perform UPDATE operations that cover multiple tables?
>
>
>
> UPDATE items,  month SET items.price=month.price
>
> WHERE items.id=month.id;
>
>
>
> If it is, what Am I doing wrong, as when I try to run it on IBConsole I get
>
> errors regarding the , between table names.
>
>
>
> Thanks
>
>
>
> daniel
>
>
>
> ____________________________
>
> Comvision Pty. Ltd.
>
>
>
> www.comvision.net.au
>
>
>
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>  
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>  
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>
>
>
>
>
>
>
>
>

"See how deep the rabbit hole goes...."