Hi Peter, Try this
SELECT courses.course_number AS "Course code", courses.course_name AS "Course", CONCAT(borrowers.surname, ', ', borrowers.firstname, ' (', borrowers.cardnumber, ')') AS "Course teacher", biblio.title AS "Title", biblio.author AS "Author", biblioitems.isbn AS "ISBN", items.itype AS "Item type", items.itemcallnumber AS "Item callnumber", items.barcode AS "Item barcode" FROM course_items LEFT JOIN items USING (itemnumber) LEFT JOIN biblio USING (biblionumber) LEFT JOIN biblioitems USING (biblionumber) LEFT JOIN course_reserves USING (ci_id) LEFT JOIN courses USING (course_id) LEFT JOIN course_instructors USING (course_id) LEFT JOIN borrowers USING (borrowernumber) Adapted from https://wiki.koha-community.org/wiki/SQL_Reports_Library#All_course_reserve_items -- Caroline Cyr La Rose, M.L.I.S Librarian | Product Manager, inLibro Le 19 janvier 2019 à 01:19:40, Peter Lau (peter....@yccece.edu.hk) a écrit: I would like to draw a list of all items cataloged under Course Reserve including the Course Code, Course teacher (if input), Bib title, Bib author, ISBN etc. I don't know how to draw them easily from the report function. Thanks and regards, *Peter Lau* Librarian Tel: (852) 3977 9868 | Email: peter....@yccece.edu.hk <libr...@yccece.edu.hk> | Fax: (852) 23384320 2 Tin Wan Hill Road, Tin Wan, Aberdeen *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha