Results 1 to 9 of 9

Thread: select Max and null value

Threaded View

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    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
  •