Hi all,

I have mytable.dbf contains 3 fields

group limitamount option

AAAAA 1000 YES
AAAAA 2000 NO
AAAAA 3000 NO
AAAAA 4000 NO

BBBBB 5000 NO
CCCCC 6000 NO

DDDDD 7000 YES
DDDDD 8000 NO

EEEEE 9000 NO
FFFFF 2000 NO

How to do select SQL statments in order to have mynewtable.dbf ?

group limitamount option

AAAAA 1000 YES
AAAAA 0 NO
AAAAA 0 NO
AAAAA 0 NO

BBBBB 5000 NO
CCCCC 6000 NO

DDDDD 7000 YES
DDDDD 0 NO

EEEEE 9000 NO
FFFFF 2000 NO

In this above example, we need to replace in group AAAAA 3 records with option = NO and group DDDDD 1 record with option = NO to become zero.

TIA for any help in coding in SQL statments.