You're welcome

>Thanks Gregory, it worked! :)
>
>Enmanuel
>
>>
>>You can use the nvl() function as in
>>
>>

>>select Table1.*, ;
>>       nvl(table2.NumField, $0) as NumField ;
>>    from Table1 left join Table2 on ...
>>