>> 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.
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