Just need to add the WHERE clause from the second one to the first:<br><br><br>SELECT borrowers.surname, borrowers.firstname, borrowers.cardnumber, issues.date_due,(TO_DAYS(curdate())-TO_DAYS(date_due)) AS 'days overdue',items.itemcallnumber, items.barcode, biblio.title, biblio.author FROM borrowers LEFT JOIN issues ON (borrowers.borrowernumber=issues.borrowernumber) LEFT JOIN items ON (issues.itemnumber=items.itemnumber) LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) WHERE (TO_DAYS(curdate())-TO_DAYS(date_due)) >= '28' AND homebranch = 'LIBRARY' AND ' ' IN (borrowers.email) ORDER BY issues.date_due asc, borrowers.surname ASC<br>
<br><br>Nicole<br><br><div class="gmail_quote">2009/8/12 Melanie Hedgespeth <span dir="ltr"><<a href="mailto:melanie@salpublib.org">melanie@salpublib.org</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<p><span style="font-size: 10pt; font-family: "Courier New";">SELECT
borrowers.surname, borrowers.firstname, borrowers.cardnumber,
issues.date_due, </span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";">
(TO_DAYS(curdate())-TO_DAYS(date_due)) AS 'days overdue', </span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";">
items.itemcallnumber, items.barcode, biblio.title, biblio.author</span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";">FROM
borrowers</span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";">LEFT
JOIN issues ON (borrowers.borrowernumber=issues.borrowernumber) </span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";">LEFT
JOIN items ON (issues.itemnumber=items.itemnumber)</span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";">LEFT
JOIN biblio ON (items.biblionumber=biblio.biblionumber) </span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";">WHERE
(TO_DAYS(curdate())-TO_DAYS(date_due)) >= '28' AND homebranch = 'LIBRARY' </span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";">ORDER
BY issues.date_due asc, borrowers.surname ASC</span></p></blockquote></div><br>