Hi all,

country state area citizenCode income
------- ----- ----- ----------- ------
001 001 001 0001 1000
001 001 001 0001 500
001 001 001 0002 1000
001 002 001 0001 1000

i got such data table. i wish to generate a query for table adapter that wound able to sum then total income according to the citizen in the same country, state, area. Mean the result would be

country state area citizenCode income
------- ----- ----- ----------- ------
001 001 001 0001 1500
001 001 001 0002 1000
001 002 001 0001 1000

since too many selected fields, in my query it dint sum up the total income for first 2 records.

how should the queary looks like??