How would I insert another column in the results table of this report to show
the biblio number as well? I keep getting syntax errors with everything I try.
SELECT barcode, itemcallnumber
FROM items
WHERE datelastseen < CAST(<<Date of stocktake (YYYY-MM-DD)>> AS DATETIME)
AND homebranch = <<Choose branch|branches>>
AND itemnumber NOT IN
(SELECT itemnumber FROM issues)
ORDER BY barcode
Thank you for your help,
Kerrie
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
