Hi.

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

TIA!

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