>> SELECT * FROM lc1 INNER JOIN lc2 ON lc1.company=lc2.company INTO CURSOR
>> lc3
>>
>> PROBLEM is the cursor now is of structure :
>> Company_a
>> Basic_a
>> Company_b
>> Basic_b
>
>explicitly name the fields you want in the 3rd query instead of using *
>
>Arnon
Hi Arnon,
Actually the period is user defined where it's not fixed as prior example I put it. It can be more than 2 months. User will defined a period range and I need to produce a cross-tab of :
Basic 1996-01 Basic 1996-02 .........
Company 1000 2000
so on

Thanks for the help.