[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 this? Warm regards James