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 <[email protected]> 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
> [email protected]
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
