------------------------

I am working on library database.<br>In database there is one table called "TB_MEMBER"<br>its column are "C_M_FINE" and "C_MEM_ID".C_MEM_ID is our primary key.

<br> Similarly the other table is "TB_MEMBER STATUS" and its column is "C_M_S_FINE" .here "C_MEM_ID" and "C_BOOKID " will be composite key.

<br>In table "TB_MEMBER STATUS" the column "C_M_S_FINE" will have max 3 enteries of fine for particalar member.

<br>and in table "TB_MEMBER" , the column "C_M_FINE" contain the sum of "C_M_S_FINE" column from "TB_MEMBER STATUS" table.<br>

<br>so how could i implement this in table. <br>Is this possible in sql server 2000 to write a query to get the value of the column.

TB_MEMBER

C_MEM_ID |C_M_FINE|
1 | 8 |
| |

TB_MEMBER STATUS

C_MEM_ID | C_BOOKID |C_M_S_FINE |
1 | 20 | 5
1 | 15 | 3
1 | 30 | 0
| |

Insert into TB_MEMBER values( --- query----- )
PLZ reply me soon.<br>I am waiting.<br>thanks<br><br>