Hi..
I have the following query .I have 3 tables..Need the result in table 4 as..
Table a
Teacher Students
Mohan pankaj
Mohan sudeepa
Mohan sujitra
Mohan Sumit
Table b (semester 1 marks)
Pankaj Maths 50
Pankaj English 40
Pankaj Physics 60
Sudeepa Chemisty 40
Sujitra Physic 10
Sujitra English 40
Sujitra Hindi 70
Table c (semester 2 marks)
Pankaj Chemistry 50
Pankaj English 40
Pankaj Physics 60
Sudeepa Science 40
Sujitra Physic 10
Sujitra Maths 40
Sujitra Hindi 70
O/p Result table
Maths 90
English 80
Physics 140
Chemistry 110
Hindi 140
Science 40
Result table is summation of all subjects...with all subjects name..Can anyone suggest any query for the same