Hello Kerrie,
This should work:
Select title, author, i.itemcallnumber from biblio b
Left join biblioitems bi on b.biblionumber=bi.biblionumber
Left join items i on bi.biblionumber=i.biblionumber
where i.barcode IN ("BARCODE1", "BARCODE2", "BARCODE3");
GL,
Pedro Amorim
On 11 December 2017 at 04:39, SATISH <lis4sat...@gmail.com> wrote:
> And Barcodes can be searched with wild cards '%' or '_'
>
> eg: 45% results in
> 45, 451,452,453..459, 4500
> this would help you to some extent.
> _______________________________________________
> 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
