-
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
-
Forum Rules
|
|