[Koha] SQL help
Patricia Dowling
Patricia.Dowling at oireachtas.ie
Thu Aug 20 02:11:56 NZST 2020
I wonder if anyone in the community can steer me on this basic SQL query? I am a very novice SQL user so apologies in advance!
I want to get a list of bibnumbers for all records with a value of “Irish Office pamphlets” in the 440a tag (series) with title, author and publication date so that I can export this list to excel as a csv file.
I have had a look around the Reports Library but got bogged down between the various tables biblio, items, marcxml etc.)
Thanks in advance!
Patricia
Patricia Dowling,
Research Librarian,
Oireachtas Library & Research Service,
Leinster House,
Dublin 2,
Ireland
patricia.dowling at oireachtas.ie
tel: (01) 6184311
Central Enquiry Desk: Tel. 00 353 1 6184701
Email library.and.research at oireachtas.ie<mailto:library.and.research at oireachtas.ie>
________________________________
Oireachtas email policy and disclaimer. http://www.oireachtas.ie/parliament/about/oireachtasemailpolicyanddisclaimer/
Beartas ríomhphoist an Oireachtais agus séanadh. http://www.oireachtas.ie/parliament/ga/eolas/beartasriomhphoistanoireachtaisagusseanadh/
More information about the Koha
mailing list