SELECT MAX question - Mailing list pgsql-general

From Jacob
Subject SELECT MAX question
Date
Msg-id 3ac68e33_3@news.uncensored-news.com
Whole thread Raw
Responses Re: SELECT MAX question
List pgsql-general
I have an sql tatement in my ASP page that has a WHERE date = (SELECT
MAX(other_date) FROM SomeTable WHERE Blah1 = Blah2) clause.  What's
happening is that the query is grabbing the latest date ONLY if something
something is in the "other_date" field.  If the "other_date" field is blank,
then the record is not chosen.  My question is, how do I grab the latest
date of "other_date" even if the it happens to be blank?



______________________________________________________________________
Posted Via Uncensored-News.Com - Still Only $9.95 - http://www.uncensored-news.com
   With Seven Servers In California And Texas - The Worlds Uncensored News Source


pgsql-general by date:

Previous
From: "IGB.NET"
Date:
Subject: ...
Next
From: "Eric G. Miller"
Date:
Subject: Re: SQL Script