Hi Folks, So, I'm working on this project management system. We have projects and tasks within projects. Both are in the same table. Not all projects have tasks, but a task must be associated with a project. Output might look like so: PROJECT duedate task1 duedate task2 duedate Okay, that's fine. But now they want to be able to order the output by the nearest date in the group of duedates. In other words, if the project is due next year, but one of the tasks is due tomorrow, they want the project to be at the top of the list of items. Here's the brief table: projectid (num) projectname (varchar2) duedate (date) parentid (num or null) There's more in the table, but you get the idea. Thoughts on pulling grouped data by the max(duedate) of the group? Thanks! -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists