Re: MySQL and GROUP BY

> At the moment I am doing something like this for my SQL statement > (simplified for just the bit I need to figure out): > > SELECT * FROM My_Table ORDER BY Business_Name, Last_Name, First_Name; > > What I would _like_ to have happen is that the select list will end up > sorted by business name as well as last name and then first name. At > the moment this query is resulting in all business names (sorted) and > then, following all business names, all last/first names (also sorted). SELECT Concat(First_Name, " ", Last_Name, Business_Name) as Name From My_Table order by Name -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key