Hi - I've read the threads about converting rows of data into columns,
but those threads assume the number of distinct rows is very limited
(say 7 for days of week).
Instead, I have a table like this:
id date date type
1 ... a
1 ... b
....
2 .... a
2 .... d
Where the number of distinct id values is in the 100,000 range
but the distinct date types are limited to about 20.
I want to get a table (not a view) like this:
id date a date b date d ......
1 x y null
2 z null w
(based on the values in the first table above)
So...I can't think how to do this. Help would be appreciated.
TIA.
dmh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
