I'm using PHP with mySQL since a long time. But now I got a question: I need to generate a SQL-Statement to fetch rows with one DISTINCT criteria. To make things clear: I don't want to fetch a single DISTINCT column, I want to fetch the whole row, where one column is DISTINCT. Can someone explain me how to do this? Kind regards Lars Hilsebein ______________________________ <mailto:lars.hilsebein@xxxxxxxxxxxxxx> lars.hilsebein@xxxxxxxxxxxxxx ------------------------------ mock&more i-net-solutions(r) Horstmarer Landweg 107 D-48149 Muenster Tel. +49 251 14490-200 Durchwahl 14490-201 Fax 14490-240 mobil +49 177 3295900 Mail info@xxxxxxxxxxxxxx <mailto:info@xxxxxxxxxxxxxx> ==============================