[Koha] SQL help request

[vikram zadgaonkar]

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 <KStevens at harvest.edu.au>
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
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>