[Koha] SQL help please

[Katrin]

Hi Kerry,

you are right, I think this one should be better:

SELECT
i.itemnumber,
i.biblionumber,
b.title,
b.author,
i.itemcallnumber,
i.barcode,
i.homebranch
FROM
items i
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
WHERE homebranch = "QLD"
AND i.biblionumber not in (select distinct i2.biblionumber from items i2 
where homebranch != "QLD")
ORDER BY i.itemcallnumber

If you want holdingbranch instead of holdingbranch you can just replace it.

Hope this works,

Katrin


On 12.04.2017 23:52, Kerrie Stevens wrote:
>
> SELECT
> i.itemnumber,
> b.title,
> b.author,
> i.itemcallnumber,
> i.barcode,
> i.homebranch
> FROM
> items i
> LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
> WHERE homebranch = "QLD"
> AND i.biblionumber not in (SELECT biblionumber FROM items WHERE 
> i.homebranch != "QLD")
> ORDER BY i.itemcallnumber
>