Thanks. 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
