thanks for your helps ,

that solution seems the best for me ,
even because it is a 1.5 version .

Maurizio





________________________________

>Though, thinking about it Dimitry, it is possible without WITH (and
>hence, with older Firebird versions) through using subselects:

>select distinct coalesce(a.cola1, b.COLB1) as Col1,
>coalesce((select sum(ta.cola2) from tablea ta where ta.cola1 = a.cola1),
>0) as total1,
>coalesce((select sum(tb.colb2) from tableb tb where tb.colb1 = b.colb1),
>0) as total2
>from tablea a
>full join tableb b on a.cola1=b.colb1

Passa a Yahoo! Mail.

La webmail che ti offre GRATIS spazio illimitato,
antispam e messenger integrato.
http://it.mail.yahoo.com/%c2%a0%c2%a0%c2%a0%c2%a0%c2%a0%c2%a0%c2%a0%c2%a0%c2%a0%c2%a0%c2%a0%c2%a0%c2%a0%c2%a0

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