hello there;

im trying to use the following piece of code but it doest work,

UPDATE itermdesc SET qnty = ( SELECT qnty -1
FROM itermdesc
WHERE itermcode =1001 )
WHERE itermcode =1001

it display the following error

You can't specify target table 'itermdesc' for update in FROM clause

Any quick help would be much appreciated!
thanx