Hi ALL,

I have a problem with one of the ouputs from a table.

The table looks like this:

due_date events count(due_date)
4/5/2005 Affina 1
4/5/2005 Ionics 1
4/5/2005 Ultimate 1
5/5/2005 Dresser 1
5/5/2005 First 1
6/5/2005 Ofoto 1

I want the table to look like this:

Due_date Slot1 Slot2 Slot3
4/5/2005 Affina Ionics Ultimate
5/5/2005 Dresser First NULL
6/5/2005 Ofoto NULL NULL


Can somebody please help me on how to get the resultatnt table using a SQL
Query.

Or if any suggestions on how i have to go about this.

Thanks
Madhavan
Bangalore
INDIA

this is not to realize in a simple query. I think you have to write a little more complex procedure or script to get out this result from your table.

what database do you use?