[Resolved] GROUP by help

[SideShowBob]

I have 2 tables, projects and updates containing data.

I am running the following query to extract data.

SELECT projects.orderbook, projects.project_name, projects.startdate, projects.enddate, updates.date, updates.Update FROM projects, updates WHERE updates.orderbook = projects.orderbook GROUP BY projects.project_name, projects.startdate, projects.enddate.

The data in projects does not change but the data in updates is added to each week.

What I want to do is the output the following.

project_name, startdate, enddate

as a header

and then

date, updates in a table fomat

so the output would be

Project 1 Name, Start Date, End Date

Date, Update
Date, Update
Date, Update

Project 2 Name, Start Date, End Date

Date, Update
Date, Update
Date, Update

Help!!!

[Lars_Berg]

Use order by instead of group by. Handle the supression of repeating project data in the client.