select distinct account.name, callnotes.date_held
from account, callnotes
where and callnotes.status = 'Held'
and callnotes.date_held NOT BETWEEN DATE_ADD(CURDATE(), INTERVAL -10 DAY) AND CURDATE() ORDER BY `name` ASC

select account.name, max(callnotes.date_held)
from   account
       inner join callnotes on account.account_no = callnotes.account_no
where callnotes.status = 'Held'
and   callnotes.date_held < DATEADD(DAY, -10, GETDATE())
group by account.name
ORDER BY account.name ASC