Isn't this going against the ANSI SQL rules?? I thought the correct
method was something like:

update ... set something = (select b from joinexpression) where ...

This is much less ambiguous that FROM. Although you do need to
repeat select expressions when updating multiple columns (so I think
stored procs are a tidier solution).

Isn't there some proposed syntax along the lines of:

update ... set a,b,c = (select something,andanother,andathird from
join expression) where ...

This would be cool... ;)

John


--- In firebird-support@yahoogroups.com, "rodries2" <rodri_es@m...>
wrote:

> Hello
>
> I'd like to know if 'update .. from ..' is going to be implemented

in

> firebird v2.0 and the state of this feature (already in the

tracker

> on sourceforge)
>
> I´ve downloaded firebird2 HEAD from cvs and I compiled but this
> feature is not done now.
>
> Sorry about my english (I'm spanish)
>
> Regards