MySQL Forums :: PHP :: One to many concept

Hi,

I have two tables
Table 1:
projects---fields: id, title created, updated

Table 2:
tasks----fields: id, project_id, title, start_date, due_date, created, updated

Questions:

I need all those projects whose task due_date crossed the current date uniquely

Note: There may be multiple task for one projects

I have written the following query but it's showing duplicate records:

SELECT p.* FROM projects p LEFT JOIN tasks t ON p.id=t.project_id WHERE t.due_date<current date