Hi friends:

I want to do a SQL query like this in firebird:

select A.nam, isnull(A.f1,0)
from table1 as B left join table2 as A on A.f2=B.Cod

Or

select case a.f1 when null then 0 else a.f1 end
from table1 as B left join table2 as A on A.cod=B.Cod


It is possible?

Thanks in advance.


Oscar Villacis