Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement