query question...

[bruce]

hi...

continuing with my test.... (i was able to get the correct information
earlier.. thanks to all who helped!)


i have the following test tbl/information:
dog
  name	char
  status	int
  _date     timestamp
  id		int

test data
  dog
   name	status	   _date	id
    tom	 1		 01/20/07	1
    tom      2           01/21/07	2
    sue      1           01/20/07	3
    tom      3           01/22/07	4
    sue      2           01/21/07	5
    bob      1           01/20/07	6
    tom      4           01/23/07	7
    sue      3           01/22/07	5
    sue      4           01/23/07	5
    sue      3           01/24/07	5

using a query similar:

  select distinct s1.universityID
 from SvnTBL as s1
  left outer join
        (select universityID,_date from SvnTBL  where actionID =5) as s2 ON
    s1.universityID=s2.universityID
  where s2.universityID is null
  and s1.universityID='1000'
    group by s1.universityID;



i can get the unique 'name's that don't have a given actionID.

however, i'm now trying to figure out how to craft a query to get the unique
'name' (group) for when the tbl has an actionID=3 with a _date later than
the _date of the actionID=4

i've played with the inner 'select....' but can't quite seem to get what i'm
looking for...

any thoughts/comments..

thanks

-bruce