>Sorry I think I didn't make my question clear enough...
>I am now working on the enhancement project the structure of the dbf file a kind of poor design, unfortunately I've got to remain the structure of the dbf file
>the actually structure of my maintenance.dbf file is like this
>
> ref_no ser_no c_exiry fee
> AAA 0002 2/3/02 $10
> BBB 0001 8/3/02 $20
> CCC 0002 2/4/03 $10
> DDD 0003 3/2/02 $20
>
>I write the SQL as below
>
>select maintenance.ser_no, maintenance.ref_no, max(maintenance.c_expiry),; maintenance.fee from maintenance where ser_no in;
>(select cser_no from mainboard) and fee>0 and c_expiry>
>my desired result should be as below
>
> ref_no ser_no c_exiry fee
> BBB 0001 18/3/02 $20
> DDD 0003 3/2/02 $20
>
>however because the c_expiry date in record CCC has been filter out by the condition
>c_expiry>
> ref_no ser_no c_exiry fee
> AAA 0002 2/3/02 $10<-------undesire record
> BBB 0001 8/3/02 $20
> DDD 0003 3/2/02 $20
>how can I solve the problem....thank you for your help..
Hi,
Please make clear why AAAA record is undesirable and should not come in the final result.
Hitendra
Précédent
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