Subject Re: [Firebird-Architect] REPLACE, again
Author Adriano dos Santos Fernandes
Jim Starkey wrote:
> I don't understand this at all. REPLACE has been used in many database
> systems for years, and, unless I've missed something, now part of the
> standard as MERGE. The Oracle semantics are sane and sensible. The
> MySQL semantics are not.
MERGE is a complex statement that can be used as REPLACE, but with very
unfriendly syntax.

Main scope of MERGE is to get data from one table and insert/update in

It do a outer join of one table with another, if the result of one side
exist, it's updated. Otherwise it's inserted.