How to Sum of total price from multiple tables?

Question

4.00/5 (1 vote)

See more:

I need Total Price Value From multiple tables .

This is SQL SERVER Query
Select sum(Tbl_StartupBanner.Price + Tbl_SignInBanner.Price + Tbl_SignOutBanner.Price) as Total from Tbl_StartupBanner,Tbl_SignInBanner,Tbl_SignOutBanner

Tbl_StartupBanner - Price Value - 1
Tbl_SignInBanner - Price Value - 1
Tbl_SignOutBanner - Price Value is None .. There is No record in This table ...

But i need total count is : 2

Posted 2-Mar-14 19:25pm

Sai Prasad anumolu

Add a Solution

Comments

Siva Hyderabad 4-Mar-14 7:55am

+4

Siva Hyderabad 4-Mar-14 23:45pm

tell me?

Sai Prasad anumolu 25-Mar-14 6:46am

dtgetdetails = objMyBAL.getLogindetails(objPL);

if (dtgetdetails.Rows.Count > 0)
{
Session["username"] = dtgetdetails.Rows[0]["username"].ToString();
Session["lastlogin"] = dtgetdetails.Rows[0]["lastlogin"].ToString();
Session["roletype"] = dtgetdetails.Rows[0]["roletype"].ToString();

Response.Redirect("AddEmployee.aspx");

}

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

george4986 · Accepted Answer · 2014-03-02T19:37:00

Solution 2

try this if table has record but price is null

SQL

Select (ISNULL(Tbl_StartupBanner.Price,0) + ISNULL(Tbl_SignInBanner.Price,0) + ISNULL(Tbl_SignOutBanner.Price,0)) as Total from Tbl_StartupBanner,Tbl_SignInBanner,Tbl_SignOutBanner

if table has no records try this

SQL

SELECT(	(Select ISNULL(SUM(Tbl_SignOutBanner.Price),0) FROM Tbl_SignOutBanner) +
	(Select ISNULL(SUM(Tbl_SignInBanner.Price),0) FROM Tbl_SignInBanner)+
	(Select ISNULL(SUM(Tbl_StartupBanner.Price),0) FROM Tbl_StartupBanner)
      ) as total

Posted 2-Mar-14 19:37pm

george4986

Updated 2-Mar-14 20:39pm

v2

Comments

Sai Prasad anumolu 3-Mar-14 1:50am

kk..If Price value is 1 in datatable . Total comming ..It is working but . I dont have price value in datatable . Frist two table price value is 1, 1 but third table there is not price value . I need total tables count is 2 ..

george4986 3-Mar-14 2:39am

solution updated plz check

Sai Prasad anumolu 3-Mar-14 3:20am

Thank u your Code working sir ......

george4986 3-Mar-14 3:41am

happy to hear gud luck ;-)

Sai Prasad anumolu 3-Mar-14 3:45am

I have so many douts in database ... Can u please send me you email Id Sir

King Fisher · Accepted Answer · 2014-03-02T19:29:00

Solution 1

SQL

Select sum(Tbl_StartupBanner.Price + Tbl_SignInBanner.Price + Tbl_SignOutBanner.Price) as Total from Tbl_StartupBanner,Tbl_SignInBanner,Tbl_SignOutBanner

SQL

Select (Tbl_StartupBanner.Price + Tbl_SignInBanner.Price + Tbl_SignOutBanner.Price) as Total from Tbl_StartupBanner,Tbl_SignInBanner,Tbl_SignOutBanner

Posted 2-Mar-14 19:29pm

King Fisher

Comments

Sai Prasad anumolu 3-Mar-14 1:31am

Tried sir .. When i was remove sum Total is not display

King Fisher 3-Mar-14 1:46am

what do you getting?

Sai Prasad anumolu 3-Mar-14 1:51am

Above Query is working sir , But First two table count price value is 1 , 1 but third table there is no price value .. I need total tables count is 2

King Fisher 3-Mar-14 2:00am

can show your three table structure with value and expected result Format..

Siva Hyderabad 4-Mar-14 7:54am

dont call sir to any one ?

Sai Prasad anumolu 3-Mar-14 2:07am

Price Column is common in all tables

Final Output Is :

Table Query is
create Table Tbl_StartupBanner(ImageId int primary key identity(1,1) check(ImageId between 0 and 1), ImagePath nvarchar(Max) NOT Null, Price Money )
, Tbl_SignInBanner, Tbl_SignOutBanner Two table also same query But table name is changing.

I used this Query
Select sum(Tbl_StartupBanner.Price + Tbl_SignInBanner.Price + Tbl_SignOutBanner.Price) as Total from Tbl_StartupBanner,Tbl_SignInBanner,Tbl_SignOutBanner

Final Outpu: total : There is no record and emmty Displaying sir

King Fisher 3-Mar-14 2:54am

remove the sum function