Subject put zeroes where ther are nulls in view?
Author Jorge Andrés Brugger

I´ve a view with a left join between two tables, and I want to return 0
instead of null on a field of the second table. Is this posible?

Actual result set:
Field_1 Field_2
1 1
2 2
3 null

and I want:
1 1
2 2
3 0


Jorge Andrés Brugger
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Correo electrónico: jbrugger@...