MySQL Forums :: PHP :: One to many concept

Advanced Search

One to many concept
Posted by: madan ray ()
Date: February 22, 2013 12:03AM


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


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 WHERE t.due_date<current date

Options: ReplyQuote

Subject Written By Posted
One to many concept madan ray 02/22/2013 12:03AM
Re: One to many concept Peter Brawley 02/22/2013 08:28AM
Re: One to many concept Rick James 02/22/2013 11:02AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.