Subject sql and firebird
Author checkmail


I would update a table (Primary key year and number), all records with the same ordernumber for example – but not the record where is currently in use and already updatet.


Update table set field = value where ordernumber = XXX and (not record with year 2013 and Number 1)

How can I realize this?


Best thanks.