On Thu, Sep 1, 2011 at 8:57 PM, Chris Cormack <ch...@bigballofwax.co.nz> wrote: > SELECT title,author,barcode FROM biblio,items WHERE > biblio.biblionumber=items.biblionumber AND items.itype ='you item type > goes here' AND (items.onloan is NULL or items.onloan = '') > > Thats two ' not one " :)
Or you can do this: SELECT title,author,barcode FROM biblio,items WHERE biblio.biblionumber=items.biblionumber AND items.itype = <<Item Type|itemtypes>> AND (items.onloan is NULL or items.onloan = '') So that it asks you for an item type and you don't have to edit again later. Nicole _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha