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?

yes, that's possible.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

> Actual result set:
> Field_1 Field_2
> 1 1
> 2 2
> 3 null
>
> and I want:
> 1 1
> 2 2
> 3 0
>
> TIA!