Thank You but when i try to link the itemcallnumber with the field using command:
update items.biblioitems set items.itemcallnumber=biblioitems.classification where items.biblionumber=biblioitems.biblionumber;
ERROR 1064:You have an error in your SQL syntax near 'biblioitems set items.itemcallnumber=biblioitems.classification where items.bibl' at line 1

--
Priyanka

--
Priyanka