how to find it

SunilChauhan — Fri, 14 May 2010 12:59:40 GMT

i have data sample

Tab1;

agreementid amount dpd

101 200 150

102 300 153

103 400 189

tab2;

agreementid amount dpd

101 200 180

102 300 183

i have to count (agreementid ) and sum(Amount) which cross dpd 180 .(those who has dpd ,180 will cross 180 in next month)

i.e i have to count record from 2nd table which having dpd>180 which have dpd less than 180 in first table.

Re. :how to find it

martin59 — Fri, 14 May 2010 13:45:34 GMT

Hello,

Look at this attachement.

Martin