1 -- Dodijeljene signature u skupini FB07
2 select items.itemcallnumber as novasignatura,
3 biblio.author as autor,
4 biblio.title as naslov,
5 biblioitems.publicationyear as godina,
6 biblioitems.volume as svezak,
8 biblioitems.number as stara_signatura,
12 left join biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber)
13 left join biblio on (biblioitems.biblionumber=biblio.biblionumber)
14 where itemcallnumber like 'FB07%'
15 order by itemcallnumber ;