MySQL Forums
Forum List  »  Newbie

Adding null values
Posted by: Harsha Chaithanya Kethepalle
Date: August 23, 2004 06:13AM

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.

Options: ReplyQuote

Written By
Adding null values
August 23, 2004 06:13AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.