How to Sum of total price from multiple tables?

Question

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

Girish Sapariya · Answer

hi try this sort of code declare @sum1 int= (Select sum(ISNULL( Tbl_StartupBanner .price0)) from Tbl_StartupBanner ) @sum2 int= (Select sum(ISNULL( Tbl_SignInBanner .price0)) from Tbl_SignInBanner ) @sum3 int= (Select sum(ISNULL( Tbl_SignOutBanner .price0)) from Tbl_SignOutBanner ) select (ISNULL(@sum10) + ISNULL(@sum20) + ISNULL(@sum30)) as Total Hope this helps you :)

Jignesh Trivedi · Answer

Hi there is no record in table Tbl_SignOutBanner so you get null result in inner join... use leftouter join inseted of. try... Select sum(isnull(Tbl_StartupBanner.Price0) + isnull(Tbl_SignInBanner.Price0) + isnull(Tbl_SignOutBanner.Price0)) as Total from Tbl_StartupBanner Inner join Tbl_SignInBanner on 1=1 -- specify the relation between Tbl_StartupBanner and Tbl_SignInBanner Left outer join Tbl_SignOutBanner on 1=1 -- specify the relation between Tbl_StartupBanner or Tbl_SignInBanner and Tbl_SignOutBanner hope this will help you.

Sai Prasad Anumolu · Answer

Total Not Null Above Final Query Out put Sir create Table Tbl_StartupBanner(ImageId int primary key identity(11) check(ImageId between 0 and 1) ImagePath nvarchar(Max) NOT Null Price Money ) This is table Query

Sai Prasad Anumolu · Answer

Money ....Sir

Girish Sapariya · Answer

can u display the table with data here and also its structure? that will help to understand

Girish Sapariya · Answer

what is data type of price column?

Sai Prasad Anumolu · Answer

Total is null Comming  Sir  Tbl_StartupBanner price value -1 Tbl_SignInBanner price value -1 Tbl_SignOutBanner Price Value - No Vlaue but i need total count is :2 This Query is Diplaying Total is Not Null

Girish Sapariya · Answer

Hi Try this hope this will work? Select (sum(ISNULL(Tbl_StartupBanner.Price0)) + sum(ISNULL( Tbl_SignInBanner.Price0)) + sum(ISNULL( Tbl_SignOutBanner.Price0))) as Total from Tbl_StartupBannerTbl_SignInBannerTbl_SignOutBanner Thank you :) Mark it as answer if work for you :)