select fh.head_name, fd.feesrec_amount
from sms_feesrecmaster fm, sms_feesrecdetail fd, sms_head fh, sms_feeshead sf
where fm.feesrec_id = fd.feesrec_id
and fd.feeshead_id = sf.feeshead_id
and fh.head_id = sf.head_id
and fm.year_id = '1'
and fm.school_id = '1'
and fh.school_id = '1'
and fm.feesrec_id = '2'
PRIMARY SECTION
MOSINKHAN PATHAN AAYATKHAN
1
A
4658
2
25/06/2026
0.00
600.00
0.00
0.00
870.00
0.00
0.00
0.00
1,470.00
June to June