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