Dear Friends, I have created an SQL query to create a collection list for our library. This report will display the details like Call Number, author, title etc. I could not include the element for subject or keyword. Here, I am using 650-a field for keyword in cataloguing. I could not found the details of table and field of "keyword" (650-a Topical term) in Koha. Can you help me to complete this SQL query for this report? SELECT items.itemcallnumber,biblio.author,biblio.title,biblio.copyrightdate,biblioitems.publishercode,biblioitems.place FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) ORDER BY items.itemcallnumber asc Regards, -- Vimal Kumar V. Asst. Librarian Asian School of Business Technopark, Trivandrum-695 581 Web: www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in OK Society Volunteer. http://oksociety.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White