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@lists.katipo.co.nz on behalf of Erik Lewis Sent: Tue 03/11/2009 16:00 To: koha@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha