<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Exactly the clue in I needed.<div><br></div><div>Thanks</div><div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; ">SELECT b.biblionumber, b.author, b.title, SUBSTR(i.isbn,1,10) </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; ">FROM biblio b, biblioitems i </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; ">WHERE (b.biblionumber = i.biblionumber AND i.biblionumber IS NOT NULL) </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; ">AND (b.author IS NOT NULL) AND (b.title IS NOT NULL);</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; "><br></div><div><div>On Nov 3, 2009, at 11:13 AM, Emrys Minnig wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Use IS NOT NULL in your WHERE statement. For example:<br><br>SELECT * FROM biblio WHERE title = "Slaughterhouse Five" AND isbn IS NOT NULL.<br><br>Emrys<br><br>________________________________<br><br>From: <a href="mailto:koha-bounces@lists.katipo.co.nz">koha-bounces@lists.katipo.co.nz</a> on behalf of Erik Lewis<br>Sent: Tue 03/11/2009 16:00<br>To: <a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br>Subject: [Koha] stuck and i need a mysql clue<br><br><br><br><br>How would I exclude NULL values from the author, title, or isbn fields <br>in the query.<br><br>SELECT b.biblionumber, b.author, b.title, SUBSTR(i.isbn,1,10)<br>FROM biblio b, biblioitems i<br>WHERE b.biblionumber = i.biblionumber;<br><br><br>I know it should be easy, but I'm not having much luck.<br>_______________________________________________<br>Koha mailing list<br><a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>http://lists.katipo.co.nz/mailman/listinfo/koha<br><br></div></blockquote></div><br></div></body></html>