I've a one-many cardinality situation. Two tables have pk and fk relationship, for a given primary id there will be 25 max rows in the child table. I need to generate an extract report with one record meaning is that for one-id 25 columns from child table should retrieve to a one row as a output.
upto 25 records for one given id
now i need output file as
1 a b c d ......y row values in one single output record
Appreciate your help in advance
It seems to be a simple transpose case, for which following are some related threads on forum:
Dieter's replies should help you resolve this.