Christopher Hendry wrote: >Is this a question? > >SELECT DISTINCT title, id, name from table GROUP BY title; > Ah, missing the GROUP BY. The above works perfec', thanks!