I need your Help ugrently

[ishaqani]

I have the following tables and fields.

SBcnt Table:

[SBNO]
-----------
013180
013180
013180

above 3 are unique records

SBnet Table:

[SBNO ]
--------
013180
013180
013180
013180
013180
013180

[SBNOTOTAL]
-------------
3
3
3
3
3
3

above 6 records are also important for me but the SBTOTAL value 3 should not be repeat in all fields only first record shows value 3 in SBTOTAL and remaining 5 records shows value 0. like below

[SBNO]
----------
013180
013180
013180
013180
013180
013180

[SBNOTOTAL]
-------------
3
0
0
0
0
0

above example is required. How can i count and set the SBNO 3 unique records value=3 in SBNOTOTAL field first record and remaing records with 0 value.

I have many records in SBNO field in SBnet Table with different value and want to count same from SBNO field in SBcnt Table and put the value into first record of SBNOTOTAL in SBnet Table.

Please guide me and help me through example code. would be highly appreciated.