OraFAQ Forum: SQL & PL/SQL » Calculating values from two different tables by using SQL command.

Home » SQL & PL/SQL » SQL & PL/SQL » Calculating values from two different tables by using SQL command. (Oracle 11g ver 11.2.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Calculating values from two different tables by using SQL command. [message #652688]

Thu, 16 June 2016 06:26

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

Report message to a moderator

Re: Calculating values from two different tables by using SQL command. [message #652690 is a reply to message #652688]

Thu, 16 June 2016 06:30

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Welcome to the forum.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Show us what you already tried, it seems there is no problem to add 3 columns and put it in another one.

Report message to a moderator