Join Query

Try

SELECT t.name, tr.status
FROM Tasks t
LEFT JOIN
        TaskRecords tr
        ON t.taskid = tr.taskid
        and taskDate = '2013/06/30'

---

Many Thanks & Best Regards, Hua Min