1 create temporary table callnumbers ( callnumber varchar(255) primary key, count int not null ) ;
2 insert into callnumbers select itemcallnumber,count(itemcallnumber) from items where itemcallnumber like 'FB01%' group by itemcallnumber ;
4 -- Dodijeljene signature u skupini FB01
5 select count(items.itemnumber),
6 items.itemcallnumber as novasignatura,
7 biblio.author as autor,
8 biblio.title as naslov,
9 biblioitems.publicationyear as godina,
10 biblioitems.volume as svezak,
13 biblioitems.number as stara_signatura,
14 items.ccode as zbirka,
17 left join biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber)
18 left join biblio on (biblioitems.biblionumber=biblio.biblionumber)
19 where itemcallnumber like 'FB01%'
20 group by items.itemnumber
21 order by itemcallnumber ;