how to find it

[SunilChauhan]

hi

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.

[martin59]

Hello,

Look at this attachement.

Martin