|
-
select Max and null value
if my select statement have like
select ReceiveDate,InterviewDate, max(CompleteDate), max(ApprovalDate),
OfficerName,SecondOfficer, DATEDIFF( max(ApprovalDate), ReceiveDate) as diff from Pos as P, Status as A , Records as P2
where P.UserId=A.UserId and P.UserId=P2.userId
and ApprovalDate<>'Null'
and ReceiveDate>='2010-07-02' and ApprovalDate<='2010-09-02'
if not result on this range , I still get one row that contain Null value in the whole row?
Thank you
________
Marijuana strain green crack
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
-
Forum Rules
|
|