>>Three tables contain the following data:
>>
>>Table 1: One transaction per record
>>Table 2: One date per record (child of transaction)
>>Table 3: One atribute per record (child of date)
>>
>>Table 1 records may have zero, one, or many children in Table 2
>>Table 2 records may have zero, one, or many children in Table 3
>>
>>Report should show all records from table 1, one per line
>>Under each item from table 1, report should show all its children from table 2, one per line
>>Under each item from table 2, report should show all its children from table 3, one per line
>>
>>The question: What is the easiest way to create the necesary cursor(s) to generate report
>>
>>TIA,
>>
>>Alex
>
>
>select Table1.*, ;
> Table2.*, ;
> Table3.* ;
> from Table1 ;
> left join Table2 on (Table2.FK == Table1.PK );
> left join Table3 on (Table3.FK == Table2.PK ) ;
> order by Table1.Field1, Table2.Field2, Table3.Field3 ;
> into cursor tmp
>
Thanks for the reply Gregory. I will try it, but I am not sure it will do what I need. I'll report back. Thanks.
Alex