Use the following query, this will help you:
SELECT
P.Id,
P.regno,
P.StdName,
P.ClassSection,
A.Standard,
A.Description,
A.Fee
FROM
Tbl_Sc_StudentProfile P, Tbl_Sc_Feeallocation A, Tbl_Com_SchoolProfile I
WHERE
P.Standard = A.Standard
AND P.compid = A.compid
AND A.compid = I.compid
AND P.Deleted='No'
AND P.Status='Yes'
AND P.Tc='No'
AND NOT EXISTS (
SELECT
c.description,
c.class
FROM
Tbl_Sc_FeeCollChild c
WHERE
c.class = P.classsection
and c.stdid = P.Id
and c.description = A.Description
)
GROUP BY
A.Description,
P.Id,
P.regno,
P.StdName,
P.ClassSection,
A.Standard,
A.Fee
order by
A.Standard asc