It seems you need it for a report, isn't it. If this is the case, the easiest way is to do it directly in the report.

Vlad

>>How do you want the final file to look like (give us 3-4 lines of it). Depending on that, it may be "doable" or not with SELETC(s).
>>
>>Vlad
>
>
>Thanks for your reply, I will give u the output which is coming currently and what i want:-
>
>current output :-
>
>code description date qty
>1 desc for code 1 1st Dt for code 1 1st qty for code 1
>1 desc for code 1 2nd Dt for code 1 2nd qty for code 1
>1 desc for code 1 3rd dt for code 1 3rd qty for code 1
>2 desc for code 2 1st dt for code 2 1st qty for code 2
>
>now, in the above output, code and description are field from parent tables which are repeated everytime, instead of that i want output like :-
>
>code description date qty
>1 desc for code 1 1st Dt for code 1 1st qty for code 1
> 2nd Dt for code 1 2nd qty for code 1
> 3rd dt for code 1 3rd qty for code 1
>2 desc for code 2 1st dt for code 2 1st qty for code 2
>
>where instead of repeating the parent fields, it should blank.
>
>Pls advs your comments, if it possible to do it through Sql or what is the best way to do it. I don't want to use scan..endscan.
>
>thanks in advance !!