[Koha] stuck and i need a mysql clue

[Erik Lewis]

Exactly the clue in I needed.

Thanks

SELECT b.biblionumber, b.author, b.title, SUBSTR(i.isbn,1,10)
FROM biblio b, biblioitems i
WHERE (b.biblionumber = i.biblionumber AND i.biblionumber IS NOT NULL)
AND (b.author IS NOT NULL) AND (b.title IS NOT NULL);



On Nov 3, 2009, at 11:13 AM, Emrys Minnig wrote:

> Use IS NOT NULL in your WHERE statement.   For example:
>
> SELECT * FROM biblio WHERE title = "Slaughterhouse Five" AND isbn IS  
> NOT NULL.
>
> Emrys
>
> ________________________________
>
> From: koha-bounces at lists.katipo.co.nz on behalf of Erik Lewis
> Sent: Tue 03/11/2009 16:00
> To: koha at lists.katipo.co.nz
> Subject: [Koha] stuck and i need a mysql clue
>
>
>
>
> How would I exclude NULL values from the author, title, or isbn fields
> in the query.
>
> SELECT b.biblionumber, b.author, b.title, SUBSTR(i.isbn,1,10)
> FROM biblio b, biblioitems i
> WHERE b.biblionumber = i.biblionumber;
>
>
> I know it should be easy, but I'm not having much luck.
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20091103/d0a7dd12/attachment-0001.htm