ok - then try this:select year(dateadd(month, datediff(month, 0, t.datum), 0)) as [year] ,month(dateadd(month, datediff(month, 0, t.datum), 0)) as [month] ,t.reknr ,k.bal_vw ,min(ca.expr1) as expr1from dbo.gbkmut tLEFT OUTER JOIN dbo.grtbk k ON t.reknr = k.reknrcross apply ( select sum(t1.bdr_hfl) as expr1 from dbo.gbkmut t1 LEFT OUTER JOIN dbo.grtbk k1 ON t1.reknr = k1.reknr where t1.reknr = t.reknr and isNull(k1.bal_vw, '_') = isNull(k.bal_vw, '_') and datediff(month, t1.datum, dateadd(month, datediff(month, 0, t.datum), 0)) >= 0 ) cagroup by dateadd(month, datediff(month, 0, t.datum), 0) ,t.reknr ,k.bal_vw
woops - fixed the cross apply aliases in JOIN criteriaBe One with the OptimizerTG