I have a simple query,
a table A that joins on table B
I have to sum one filed of A with one filed of B,
If B doesnt match,
I dont want the result filed keep NULL value,
but only A field value.
if A field is 1 and B field is 1, the result field is 2.
if A field is 1 and B field is NULL (because it doesn match with A table key)
the result is NULL at the moment,
I would like it results 1.
there a function which transform null value in 0 in order to resolve the issue,
or are there other ways?
select A.valA, B.valB, A.valA+B.valB as Result from
A left join on A.key=B.key