[SQL] results being col wise rather than row wise

[Hrishikesh Deshmukh]

HI All,

I have 5 tables which have different columns as shown below, each table has a different case column,
i want to retrieve sample related information as follows:

pid | xindex | yindex | height Index | flag | case1 | case 2.....etc

But i get this queer result:
pid        | xindex | yindex | Height Index | flag |     case
-------------+--------+--------+-------------+-------------+---------
102234   |    411 |    271 |           9 |           1 |      80
102234   |    411 |    271 |           9 |           1 |      83
102234   |    411 |    271 |           9 |           1 |      87
102234   |    411 |    271 |           9 |           1 |     101
102234   |    411 |    271 |           9 |           1 |     129
102234   |    411 |    271 |           9 |           1 |      91
102234   |    411 |    271 |           9 |           1 |   120.3

Why is the result in a column wise rather than row wise???!!!!
Could somebody explain why the redundancy with respect to pi, xindex, yindex, height index, flag but the CORRECT values for the cases but not in the order expected!!!


Thanks,
Hrishi