10 Nov
2016
10 Nov
'16
5:11 a.m.
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