Hi all!

Pl. help me in designing an UPDATE query. I have 2 tables.

Table 1: tblMember(mid, sponsorid, mname)
Table 2: tblCountMember(mid, sponsorid, totalCount)

Each member has a sponsor and a member becomes sponsor for other members. mid in both tables are primary and joined with 1-to-1 relationship. I want a query which will count members under each sponsor and update totalCount field in table tblCountMember with one go.
Thanks in advance.