Hi All,
Appreciate your time efforts spent to answer me!
In the wrkqry I did following
1)Specify file selections
T01.file and T02.xlfile are there
2)Type of join is 1 (Matched records)
3)Specify how to join files
T01.optcod = T02.ioptcod
T01.client = T02.iclient
T01.futur = T02.ifutur
do I have any option to replace T01.optcod with T02.NOPTCOD (something like
EVAL T01.OPTCOD =T02.NOPTCOD) under the above conditions....
My final file is FILE and I cant take any fields from T02.
JoeP
Appreciate your time efforts spent to answer me!
In the wrkqry I did following
1)Specify file selections
T01.file and T02.xlfile are there
2)Type of join is 1 (Matched records)
3)Specify how to join files
T01.optcod = T02.ioptcod
T01.client = T02.iclient
T01.futur = T02.ifutur
do I have any option to replace T01.optcod with T02.NOPTCOD (something like
EVAL T01.OPTCOD =T02.NOPTCOD) under the above conditions....
My final file is FILE and I cant take any fields from T02.
JoeP
Comment