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

Reply via email to