Re: [SQL] results being col wise rather than row wise

On Wed, 29 Mar 2006, Hrishikesh Deshmukh wrote: > 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

[SQL] results being col wise rather than row wise

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 |