That works great. =D Knew it shouldn't be that difficult, thanks a bunch. And it actually works with the Priorities being in text form to (low, med, hi).
-Nick > At 02:52 PM 7/24/2003, you wrote: >>After some searching around different books/manuals/google I still can't >>seem to figure out how do to this. What I have is a table with 4 cols >>(task, resource, department, priority) and what I want to do is be able >> to >>select distinct resources and list what their highest priority is. >>In other words, if a resource is in a high priority task and a low >>priority task, I only want to show the high priority task. >> >>Thanks for the help! >>-Nick > > Nick, > You mean something like this: > > select resource, Max(Concat(priority, '=', Resource)) ResourcePriority > group by Resource > > This will work with priority 1 through 9. > > Mike > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
