This is nothing more than a SYNTAX problem, and as soon FireBird has
this feature it'll have the appropriate syntax.
It's much more flexible and easy (for the user, not for FireBird
which doesn't matter), specially when linking not just 2 tables ...

--- In firebird-support@yahoogroups.com, Sándor Tamás (HostWare Kft.)
<sandortamas@...> wrote:

>
> Maybe you're right, and it'll be in future Firebird distributions.

But it's still illogical. How can I update FROM anything? I can only
update somtehing. And if I use Inner join, which table will be
updated? I think it's much more logical to update something, where I
can't find appropriate records in another table.

>
> SanTa
>
> ----- Original Message -----
> From: Roberto Freitas
> To: firebird-support@yahoogroups.com
> Sent: Tuesday, July 11, 2006 4:38 PM
> Subject: [firebird-support] Re: UPDATE AND DELETE WITH JOIN
>
>
> I think it's a pitty that FireBird (such an excelent DB Server)
> hasn't YET this feature, because it's much more flexible to do

update

> and delete with INNER JOINS than the way to do the same with

FireBird.

> I could bet it'll have in the future ...
>
> --- In firebird-support@yahoogroups.com, Ali Gökçen <ali_gokcen@>
> wrote:
> >
> > Hi Roberto
> >
> > > This is a valid sentence with SQL Server:
> >
> > Really? what a pitty for MSSQL users.
> >
> > > UPDATE MAT SET MAT.MT=137
> > > FROM MAT INNER JOIN ALU ON MAT.ALREG = ALU.ALREG
> > > WHERE ALU.EDCOD='TWQ';
> > > With FireBird 1.5 I get Token unknow line 2 char 1 FROM
> > > How can I do this kind of UPDATE with FireBird 1.5?
> > > How can I do a similar DELETE (with JOIN) with FireBird 1.5?
> > >
> >
> > You are allready saying "UPDATE MAT",
> > so, what is it for "FROM MAT" ?
> >
> > Try this:
> > UPDATE MAT SET MAT.MT=137
> > WHERE EXISTS (SELECT 1 FROM ALU WHERE MAT.ALREG = ALU.ALREG
> > AND ALU.EDCOD='TWQ')
> >
> > Regards.
> > Ali
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>