I have a table "WCR (l,j,W,C,R)" with the following entries. Here, l and j are primary keys.
I have to insert data from column C of WCR into another table C(l,C1,C2) where l is the primary key. The C table will be as follows -
For each l, j=1...