At 05:13 PM 3/05/2008, Vlad Khorsun wrote:

>>> I never seen a update with a inner join.
>>>
>>> Can this be?
>>>
>> It's a common, but non-standard extension to SQL. Like many
>> non-standard extensions, it's pretty intuitive and useful in
>> simple cases, but leads to very odd corner conditions.
>
> Exactly. Therefore FB 2.1 implemens standard MERGE statement.

As UPDATE OR INSERT, yes? I think we lost MERGE after the alpha...or is it hiding in there?

./heLen