Return 0 for no record

[mrliam69]

I am trying to set up a calculation in a view against 2 tables.

Basically I have an embedded select statement + embedded select statement the problem is if either embedded select statement returns no rows then the calculation fails. Any ideas how I can get around this ?

(embedded select statement)
+
(embedded select statement)

Cheers

Liam

 

[DotNetGnat]

use a CASE statement to return 0

-DNG

 

[r937]

coalesce((embedded select statement),0)
+
coalesce((embedded select statement),0)

r937.com | rudy.ca

 

[mrliam69]

Cheers for the replies.

I had tried coalesce but it kept failing finally figured it out...

(select coalesce((embedded select statement),0))
+
(select coalesce((embedded select statement),0))

Cheers