> >A subselect may help: > >[...] > >Don't know ATM if it can be done more easily, but a query like this > >should probably work. > > > It can be done without a sub-query: > [...] > > That *should* work, barring any typos or ommisions I may have made. I > used LEFT JOIN because of personal preference, it can be done other way(s).
Ah yes, I see. Nice idea. As JOINs perform better than subselects IIRC, your solution ought to be preferred, then. Fred -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]