Posted by 4partee on 09/26/40 11:37

On Sun, 15 Jan 2006 19:28:14 -0500, Jerry Stuckle wrote:

> manny wrote:
>> I wish I knew what this was called, and I could have made a more sensible
>> subject. For that matter, I knew what it was called, I could have googled it!
>>
>> Anyway, let's I have a table with name, class, grade.
>>
>> joe bio a
>> jill chem b
>> john psych b
>> john chem a
>> jill pysch a
>>
>> and I want to display the results as
>>
>> name bio psych chem
>> joe a - -
>> jill - a b
>> john - b a
>>
>> Is there a way to do this with sql? How about sql with php?
>>
>> Thanks much!
>>
>> Manny
>

SELECT name, IF(class = 'bio', grade,'-') AS `bio`
, IF(class = 'psych', grade,'-') AS `psych`
, IF(class = 'chem', grade,'-') AS `chem`
from tablex

Actually, mysql really sucks at this!

John

• Next in forum: Re: How do I do this query?
• Prev in forum: Re: How do I do this query?
• Thread view: Re: How do I do this query?

[Reply to this message]