Adding null values

[Harsha Chaithanya Kethepalle]

Hello all,

I have a problem with my select statement.

I have two tables from whic I am getting two int fileds and I want to add both the fields. I am able to add them but my problem is, one of the two fields may be null, then I am not getting the value at all, the total field is null.

int field a from table ABC
int field b from table XYZ

creating new table TOTAL wit fields sum(a), sum(b), c (c = a + b)..(all int fields)

now the output of c is right when both a & b r not null, and if anyone of them is null, the value for c is also null.

How could I get the value to c even if one of the two values r null.

Thanks in advance.