Hi,
Please check following:
SELECT barcode, itemcallnumber,biblionumber
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
Vikram Zadgaonkar
On Thu, Nov 10, 2016 at 9:41 AM, Kerrie Stevens <[email protected]>
wrote:
> 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
>
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
