18 Mar
2020
18 Mar
'20
9:29 a.m.
Hello All, I have imported a MARC file 2-3 times with the same records, getting errors some times so fixed and imported the same again and again. Now when I use search, getting duplicate results for the books, few of the have barcode and others shows 'No items". So fix the issue I have created a query which delete unused biblio from the table, please let me know will it create another issue or not? *delete from biblio where biblionumber not in (select biblionumber from items)delete from biblioitems where biblioitemnumber not in (select biblioitemnumber from items)* -- Thanks, Laxmilal Menaria | +91 982 955 3793 | http://cloud-computing.solutions/