Re: [Koha] [koha] COMBINE SQL REPORTS TO ONE WITH COLUMNS

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 

[Koha] [koha] COMBINE SQL REPORTS TO ONE WITH COLUMNS

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