X, Y Table structure

[Anonymous Monk]

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:

	Sizes
QTY	1	2	3	4	5
100	$43	$45	$50
200				$55
250	$52	$55	$56		$61

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 ).