Results 1 to 1 of 1

Thread: select cross tables with Max date and date range

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    select cross tables with Max date and date range

    I have table 1 name, userId
    table 2 ReceiveDate,InterviewDate, UserId
    table 3, CompleteDate, ApprovalDate, userid
    table 1and 2 is one to one , table 3 and table 1 is one to many

    I want to select name, ReceiveDate,InterviewDate, max(CompleteDate), max(ApprovalDate) where ReceiveDate>='2010-01-01' and ApprovalDate<='2010-02-02'
    ________
    Synthetic weed
    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
  •