From a843264a42bade792937ea4aaa7e8aa706d61859 Mon Sep 17 00:00:00 2001 From: Marijana Glavica Date: Fri, 12 Dec 2008 01:33:02 +0100 Subject: [PATCH] slf-signature/14-14.sql --- slf-signature/14-14.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 slf-signature/14-14.sql diff --git a/slf-signature/14-14.sql b/slf-signature/14-14.sql new file mode 100644 index 0000000..32d822f --- /dev/null +++ b/slf-signature/14-14.sql @@ -0,0 +1,15 @@ +-- Dodijeljene signature u skupini D14 +select items.itemcallnumber as novasignatura, + biblio.author as autor, + biblio.title as naslov, + biblioitems.publishercode as izdavac, + biblioitems.publicationyear as godina, + biblioitems.volume as svezak, + items.biblionumber, + biblioitems.number as starasignatura, + items.timestamp +from items +left join biblio on (items.biblionumber=biblio.biblionumber) +left join biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) +where items.itemcallnumber is not null and items.itemcallnumber like 'D14%' +order by items.itemcallnumber ; -- 2.20.1