Hi Valentina Developers,
Now you can use in Valentina 6.0 a new powerful command 'MERGE'. This command is from SQL2003 standard.
This command allows you to combine by some logic INSERT, UPDATE, DELETE in the single command. On of the simplest tasks it can solve - is so named UPSERT = UPdate + inSERT
In the SQL2003 standard they talk only about UPDATE and INSERT. We have take some ideas from MS SQL, to be able to do DELETE also.
You can read syntax of this new command on WIKI page about Valentina SQL 6.0 Grammar