[Koha] SQL help please

[Pedro Amorim]

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 <lis4satish at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>