My error seemed to be just in the group declaration. Comparing yours and mine with slight modifications to yours that eventually worked as desired:
yours:
select e.id, title, min(event_date) as event_date from eventTable e, dateTable d where e.id = d.event_key group by e.id;
mine:
select e.*,min(d.event_date) as event_date from eventTable e,dateTable d where e.id = d.event_key group by d.event_date,d.event_key;
As you see, I was already trying to do a join, but the group by was throwing me.
Terry
On Wednesday, November 6, 2002, at 09:15 AM, Marco Tabini wrote:
My guess? Because we're all professionals at work and trying to solve a specific problem...since we're adults, I guess the learning part should be up to each of us--the information is certainly there even in the answer. :-)Marco --
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
