From 2aa4c49f78429b1380f6e479f09ed7bd253f9be9 Mon Sep 17 00:00:00 2001 From: Marijana Glavica Date: Fri, 16 Jan 2009 03:57:29 +0100 Subject: [PATCH] psi-signature/01-01.sql --- psi-signature/01-01.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 psi-signature/01-01.sql diff --git a/psi-signature/01-01.sql b/psi-signature/01-01.sql new file mode 100644 index 0000000..1b7f060 --- /dev/null +++ b/psi-signature/01-01.sql @@ -0,0 +1,17 @@ +-- Dodijeljene signature u skupini BC01 +select + callnumbers.count as signatura, + items.itemcallnumber as novasignatura, + biblio.author as autor, + biblio.title as naslov, + biblioitems.publicationyear as godina, + biblioitems.volume as svezak, + items.biblionumber, + biblioitems.number as starasignatura, + items.timestamp +from items +left join biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) +left join biblio on (biblioitems.biblionumber=biblio.biblionumber) +LEFT JOIN callnumbers on (items.itemcallnumber=callnumbers.callnumber) +where items.itemcallnumber is not null and items.itemcallnumber like 'BC01%' +order by items.itemcallnumber ; -- 2.20.1