Results 1 to 2 of 2
May 26, 2004, 12:58 #1
- Join Date
- Nov 2001
- Washington DC
- 0 Post(s)
- 0 Thread(s)
How to deal with missing values in IN clause
I need to select the max value for the time field in a table for a given range of values in the id field like so...
SELECT id, max(time) from TABLE where date = '2004-05-01' and id IN (15,16,18,21) group by id
This is an incredibly simplified version of my query (there are actually 1000s of ids within many tables and doing some math to subtract the current time from the last update time) so breaking these into individual queries would really slow things down too much.
Any idea how I can force it to return a known/static/null/any value for every id regardless of whether it matches a row or not?
--ViralA computer without Windows is like a chocolate cake without mustard.