I think you are a "artificial intelligence" prototype ;) The answer was
correct, but totally useless ...

Best regards

Martijn Tonies wrote:

>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!
>>
>>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
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



[Non-text portions of this message have been removed]