what is wrong in my subsquer? I get more records then it should show
Code:
select PostS.UniversityN, FeeType, StudentVisa, Curriculumlist, count(PostS.UniversityN) from PostS, PaymentRecords, PostD
where PostS.UserId=PaymentRecords.UserId
and PostS.UserId=PostD.UserId
and PostS.UniversityN in (
select PostS.UniversityN from PostS, PaymentRecords, PostD
where PostS.UserId=PaymentRecords.UserId
and PostS.UserId=PostDe.UserId
and processStatus !='Pending approval'
group by PaymentRecords.UserId, DueDate, ProcessStatus, ApprovalDate,DefferredPayDate, left (FeeType, 8)
having count(UpdateId) >1)
and processStatus !='Pending approval' group by FeeType, StudentVisa,PostS.UniversityN order by PostStatus.UniversityN;
________
WEEDMAPS