Here is the query...

SELECT a.no as no, a.date as date, a.key as key, a.memo as memo, b.name as name

FROM Cases_Table a INNER JOIN Dates_Table b on a.key = b.key

WHERE b.Name LIKE '%TICKLER%' AND len(a.memo) > 0 ORDER BY name, date, no