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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
