dcsimg
Results 1 to 1 of 1

Thread: what is wrong in my subsquer?

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    what is wrong in my subsquer?

    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
    Last edited by sql; 03-06-2011 at 02:16 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •