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
