> 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

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to