Re: What's wrong with this? (Left Join)

[Chris Stubben]

Actually, if you have 4.1, the GROUP_CONCAT function would be better than max... that way if you do have multiple values for a given upload and name combination, they will be all be included in a single column separated list.

select upload,
GROUP_CONCAT( if (name='Address', value, NULL) ) as Address,
GROUP_CONCAT( if (name='City', value, NULL) ) as City,
GROUP_CONCAT( if (name='State', value, NULL) ) as State,
....

FROM ezu_uploadinfos
GROUP by 1;