Oleg LOA wrote:
with t1 as (select 1 f1,1 f2 from dual union all select 1 f1,1 f2 from dual union all select 1 f1,1 f2 from dual),t2 as (select 1 f1,1 f2 from dual union all select 1 f1,1 f2 from dual) select (select sum(t1.f1) from t2) from t1
А вот так: select (select sum(t1.f1) from t2 where t1.f2 = t2.f2) from t1 ? -- Дмитрий Еманов
