Hello,

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.

Regards

Olaf