How to Sum of total price from multiple tables?

Mar 3 2014 1:22 AM

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