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