Hello
right now I have a table which looks like this
(including duplicate entries)
Error Date
A001 2004-07-08
A001 2004-07-08
A222 2004-07-08
A001 2004-07-09
Now I query for the quantity one error occurs during a
day (select Date, Error,
Count(*) FROM table1 GROUP BY Date and Error). The
result looks like this:
Date Error Quantity
2004-07-08 A001 2
2004-07-08 A222 1
2004-07-09 A001 1
What I would like to have right now is a result which
looks like this:
Date 2004-07-08 2004-07-08
Error
A001 1 1
A222 2 0
As a header I would like to have the dates and than
display the error on the left side and the quantity of
how often the error occures beneath under each date.
My problem is, that I do not always have an entry for
every error per day.
Anybody knows how to do that?
Thank you very much for your help.
Jonas
___________________________________________________________
Gesendet von Yahoo! Mail - Jetzt mit 100MB Speicher kostenlos - Hier anmelden:
http://mail.yahoo.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
