| How to Group [message #90105] |
Thu, 28 October 2004 11:19 |
smth
Messages: 2
Registered: October 2004
|
Junior Member |
|
|
Hi,
I have a table
Name - Day - Colour
ram - Monday - white
ram - wednesday - red
mohit - Tuesday - blue
mohit - wednesday - black
mohit - friday - white
purab - monday - yellow
rajesh- tuesday - black
rajesh- saturday - brown
i have to generate a report in the below format
name - Day - Colour
ram - Monday - white
ram - Tuesday - 0
ram - wednesday - red
ram - thursday - 0
ram - friday - 0
ram - saturday - 0
ram - sunday - 0
similarly for others also for the whole week, even though they do not have details for all the days in the week
Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
