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'

Hi,

I tried this and works fine if no Task Record exists.

However, if a Task Record does exist, it returns that record, but also a number of NULL task records.