Also - no its not legal, even though you can do this in MS Access, you cannot
update 2 tables in a real sql product such as FB or SQL Server. Which way is
the update to occur? This nis invalid code, hence the , because FB "does not
compute"
Alan
Quoting Norman McFarlane <norman@...>:

>
>> 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...."
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
Alan J Davies
Aldis
Tel: +44 (0)1926 842069
Mob: +44 (0)7885 372793