Hi,

--- In firebird-support@yahoogroups.com, "Roberto Freitas"
<solanofreitas@...> wrote:

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

MS thinks like as you too.
They create complex and problematic syntaxes.(like oracle)
imagine:
you updating the utable with inner joined jtable,
at the same time somebody updated a row of jtable and not commited.
your update command will rejected by sql server (except immited v2005)
because of lock or you will wait even forever.
here, you have a function but under heavy restrictions, aspecialy on
multiuser environments.
MS and Ora gives all, whatever their users want because of money.
this doesnt mean they are right allmost.
take a look SQL world history, they allways change their structer and
immited seamless FB features.

Ali
FFM#208