RE: A difficutl query I cannot do.

2002-01-13 Thread Gordon
The following SELECT should produce your table mysql> Select id, ->Max(CASE TimeSlot -> WHEN 1 THEN Subject ->ELSE "" ->END) AS TS1, ->Max(CASE TimeSlot -> WHEN 2 THEN Subject ->ELSE "" -

Re: A difficutl query I cannot do.

2002-01-09 Thread Bob Hall
On Thu, Jan 10, 2002 at 10:24:37AM +1100, Sam Russo wrote: > I have a delimited file sent to me with students ID subjects and when they > do these subjects. This file (table) looks like: > ID TimeSlotSubject > > 215 3