Originally Posted by
Tapan
Hi all,
I am facing problem while updating data in a row in one table(say Table1) from data in column in another table(say Table2).
Table1(destination table) contains 7 fields in a single row (roll no,sub1,sub2,sub3,sub4,sub5,sub6) which need to be updated from data in Table2.
The Table2(source table) has only 3 fields, i.e., roll no and subject code and marks.
In Table2, Roll no field is the common field. subject code field contains 6 subject codes as sub1,sub2,sub3,sub4,sub5,sub6. Marks field contains 6 marks of corresponding subject codes as 21,22,23,24,25,26.
I want to know how to populate marks from Table2 in Table1 under sub1,sub2,sub3,sub4,sub5,sub6.
Please help at the earliest.
Thanking you all
Tapan