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