How to sum using two different column in SQL

Question

0.00/5 (No votes)

See more:

hello
I have two different table suppose table1 AND table2 here i want to calculate the Total Quantity from both the table (table1 + table2) using sub query & join Like.

What I have tried:

Select Sum((isnull(cast(Quantity as float),0))) from table1 

Select Sum((isnull(cast(Quantity as float),0))) from table2

i am using this two different query for getting the result can you suggest me to single query.

Posted 17-Mar-17 2:22am

AZHAR SAYYAD

Updated 17-Mar-17 2:36am

Add a Solution

Comments

Member 11137292 17-Mar-17 8:37am

Do you mean something like this?

Select Sum(TableTotal) AS GrandTotal
FROM (
Select Sum((isnull(cast(Quantity as float),0))) AS TableTotal from dbo.table1
UNION ALL
Select Sum((isnull(cast(Quantity as float),0))) AS TableTotal from dbo.table2
) AS SourceData

1 solution

Add a Solution

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

Peter Leow · Accepted Answer · 2017-03-17T02:36:00

Solution 1

Adapt from this

select (select Sum(isnull(cast(Quantity as float),0)) from table1) + (select Sum(isnull(cast(Quantity as float),0)) from table2)

Posted 17-Mar-17 2:36am

Peter Leow

Comments

AZHAR SAYYAD 17-Mar-17 10:02am

CAN WE GROUP BY USING THE id COLUMN IN THIS QUARY

How to sum using two different column in SQL

1 solution

Solution 1

Add your solution here

Preview 0

How to sum using two different column in SQL

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us