Calculating values from two different tables by using SQL command. [message #652688] |
Thu, 16 June 2016 06:26 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/adf2a4bac74c7ca82ade07a679b0689e?s=64&d=mm&r=g) |
faisal78
Messages: 1 Registered: June 2016 Location: Islamabad
|
Junior Member |
|
|
Hi,
I have three different tables, student1, student2 and Total having fields.
student1 student2 ---> Total
sno sname Math Physics English sno sname Math Physics English ---> sno sname TotalMarks
I want to have calculated TotalMarks (Math+Physics+English) from student1 and studne2 in the Total table.
Please help me about, which SQL command I would use to do this.
Regards,
Faisal
|
|
|
|
|
|
|
|