I think I did not understand ur requirement properly

Is this what u want???

Update LOTTERY_MY_NUM set NUM1= LOTTERY_WINNING_NUM.NUM1,

NUM2= LOTTERY_WINNING_NUM.NUM2,

NUM3= LOTTERY_WINNING_NUM.NUM3,

NUM4= LOTTERY_WINNING_NUM.NUM4,

NUM5= LOTTERY_WINNING_NUM.NUM5

from LOTTERY_MY_NUM A JOIN LOTTERY_WINNING_NUM ON A.RID = LOTTERY_WINNING_NUM.RID