Hi James, that is not quite what you want yet, actually it's the other way around. But maybe it will spark some ideas:
SELECT "Count of patrons" as "Type", count(*) as "Count" from borrowers UNION SELECT "Count of items", count(*) from items; Will give you: +------------------+-------+ | Type | Count | +------------------+-------+ | Count of patrons | 54 | | Count of items | 962 | +------------------+-------+ You can combine several SQL queries using UNION, you just have to make sure that the number of columns are always the same. Hope this helps, Katrin On 07.05.21 07:41, muiru james wrote:
Hello all, I have three different reports that give a count of books by DDC numbers. - Books on shelves - Books on loan - Damaged books I'm looking to combine the queries to give me one report with three columns as under: Books on shelves | Books on loan | Damaged Books Is there a way to do this? Warm regards James _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha