Hi Everyone, I need to fetch the *total items* and *total available items*(not withdrawn/lost/on loan etc) per *biblionumber*. Is there a way to do this using a single query?
The query which I am using at this point is giving me name of the homebranch and total items. select homebranch,count(*) from items where biblionumber=1234 group by homebranch; I need available items as well. Thanks in advance.! Regards -- *Mayank Srivastava* New Delhi _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
