From 1a56d990688d7b75861965d53c9989d88296db2e Mon Sep 17 00:00:00 2001 From: Marijana Glavica Date: Mon, 10 Nov 2008 13:12:27 +0100 Subject: [PATCH] ger-signature/01-01.sql --- ger-signature/01-01.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 ger-signature/01-01.sql diff --git a/ger-signature/01-01.sql b/ger-signature/01-01.sql new file mode 100644 index 0000000..ea1583c --- /dev/null +++ b/ger-signature/01-01.sql @@ -0,0 +1,21 @@ +create temporary table callnumbers ( callnumber varchar(255) primary key, count int not null ) ; +insert into callnumbers select itemcallnumber,count(itemcallnumber) from items where itemcallnumber like 'FB01%' group by itemcallnumber ; + +-- Dodijeljene signature u skupini FB01 +select count(items.itemnumber), + items.itemcallnumber as novasignatura, + biblio.author as autor, + biblio.title as naslov, + biblioitems.publicationyear as godina, + biblioitems.volume as svezak, + items.biblionumber, + items.itemnumber, + biblioitems.number as stara_signatura, + items.ccode as zbirka, + items.timestamp +from items +left join biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) +left join biblio on (biblioitems.biblionumber=biblio.biblionumber) +where itemcallnumber like 'FB01%' +group by items.itemnumber +order by itemcallnumber ; -- 2.20.1