Hi Hamis,

merge is your friend:
https://firebirdsql.org/refdocs/langrefupd21-merge.html

In FB 2.5 series only insert and update is supported.

András

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Monday, March 19, 2018 7:48 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] update or insert from in-line query



Hi,

Is UPDATE OR INSERT INTO table-name <list of columns> SELECT ...

not supported? I'm using Firebird 2.5.8.

thanks

Hamish



__________ Information from ESET Mail Security, version of virus signature database 17079 (20180319) __________

The message was checked by ESET Mail Security.
http://www.eset.com


[Non-text portions of this message have been removed]