Keep It Simple, Stupid | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
I have the following database table structure: id, size, qty, price 1 , 1 , 100, 43 2 , 1 , 250, 52 4 , 2 , 100, 45 5 , 2 , 250, 55 6 , 3 , 100, 50 7 , 3 , 250, 56 8 , 4 , 200, 55 9 , 5 , 250, 61 I am looking to get this kind of output:
My thought that this requires three sql selects, first two to get distinct values of sizes, qty and the 3rd to build data structure out of it. But I couldn't imagine the data structure that could give me the output shown above. Therefore I need your help on the most appropriate solution for this ( the data structure that works best & if this can be done in one sql query ). In reply to X, Y Table structure by Anonymous Monk
|
|