Looks like you are not using MS SQL Server. SQLTeam is on MS SQL Server. For other try asking at dbforums.com
Anyway the query below is for MS SQL Server.
select account.name, max(callnotes.date_held)
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
Time is always against us