Re: X, Y Table structure

Replies are listed 'Best First'.
Re^2: X, Y Table structure by Anonymous Monk on May 10, 2011 at 14:32 UTC
If you've seen my reply to ikegami, You can see that I've added IDs in my example.	[reply]
Re^2: X, Y Table structure by Anonymous Monk on May 10, 2011 at 12:28 UTC
FWIW, AFAIK, its temporary, for creating reports, like SQLite::VirtualTable::Pivot shows `Given this table : Student Subject Grade ------- ------- ----- Joe Reading A Joe Writing B Joe Arithmetic C Mary Reading B- Mary Writing A+ Mary Arithmetic C+ A pivot table created using the columns "Student" and "Subject" and th +e value "Grade" would yield : Student Arithmetic Reading Writing ------- ---------- ------- ---------- Joe C A B Mary C+ B- A+` [download] Because I forgot all about VIEWS/PIVOT, I did the transformation manually.	[reply] [d/l]