Joining multiple tables returns NULL value

by

That is because null on either side of the addition operator will yield a result of null. You can use ISNULL(LiabilityPremium, 0) Example:

ISNULL(l.LiabilityPremium,0) + ISNULL(h.LiabilityPremium,0) as LiabilityPremium

or you can use COALESCE instead of ISNULL.

COALESCE(l.LiabilityPremium,0) + COALESCE(h.LiabilityPremium,0) as LiabilityPremium

Edit

I am not sure if this is coincidence with this small data set or expected but if it is always expected that either @LiabilityPremium.LiabilityPremium or @HiredPremium.LiabilityPremium will always be null then there is no need to perform addition. Instead use COALESCE directly on those 2 columns.

COALESCE(l.LiabilityPremium, h.LiabilityPremium) as LiabilityPremium

More Related Contents:

  1. Update a table using JOIN in SQL Server?
  2. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  3. How to check if a column exists in a SQL Server table
  4. Combine multiple results in a subquery into a single comma-separated value
  5. Sequence as default value for a column
  6. Avg of float inconsistency
  7. Which join syntax is better?
  8. I dont know sql syntax for my table [closed]
  9. Max Nbr of Months W/ No Activity in Past 12 Months
  10. SQL server query to output the data shown below
  11. How do I generate a random number for each row in a T-SQL select?
  12. Auto increment primary key in SQL Server Management Studio 2012
  13. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  14. Floor a date in SQL server
  15. How to drop a table if it exists?
  16. Create a view with ORDER BY clause
  17. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  18. INSERT INTO vs SELECT INTO
  19. Possible to store value of one select column and use it for the next one?
  20. How FOR XML PATH(”) works when concatenating rows
  21. SQL Server variable columns name?
  22. What is the Oracle equivalent of SQL Server’s IsNull() function?
  23. SQL Recursive CTE: Finding objects linked by property
  24. PRINT statement in T-SQL
  25. T-sql – determine if value is integer
  26. Convert decimal time to hours and minutes
  27. Conditional JOIN Statement SQL Server
  28. Is there an “IF EXISTS” test for a linked server?
  29. SQL Server stored procedure return code oddity
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment