thanks Jay,

well this is the stru of the table

results table (many records up to 30 per Id)
id_fk, qty0, result0


the main parent table (one record per page)
id
pageid

now the parent is on a one to many with the results, being the key
the ID no

I have Id = 1 on the main parent table and probably about 30 entries on the
result table, how do I go by displaying those 30 Qty,results horizontaly






>Maybe?
>
>If you could be more specific with the columns/join of the 2 related tables, and what columns you want to extract from them for display, and your desired format, that would help us give a more specific response.
>
>Jay
>
>>Hello guys,
>>
>>Is there a way to query a table where I have 30 columns,
>>not all of the columns have info, this table is a one to many
>>relationship with another one (being that other one the one).
>>
>>This table have many results of the same parent record in different
>>columns up to 30
>>is there a SQL way to show this results horizontaly ?
>>
>>or do i have to write a program to report them that way ?
>>
>>tx
>>
>>mark oliva