Results 1 to 7 of 7

Thread: select in some range , but finishdate on table B

Threaded View

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    select in some range , but finishdate on table B

    I need to get rang of University head count
    Code:
    select  A.UniversityN, count(*)
    from Post
    and UpdateId like'U%'
    group  BY UniversityN and ReceiveDate>='2010-01-01' and ApprovalDate<=''2010-02-02';
    but the problem is the ApprovalDate on table B , and table Post and table Post is one to many relationship , ther connected By UserId .
    any ideal??
    ________
    Yamaha Dt250
    Last edited by sql; 03-06-2011 at 02:13 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
  •