are you receiving this?

I have sent a couple of emails to the list, but I don't know if they are posting or not, because I haven't received them back from the list, which I assumed I would. Can someone just confirm that this message is indeed being posted? -- MySQL General Mailing List For list archives: http://lists.m

nested aliases in select

Hi all. Can somebody explain to me why the following SELECT doesn't work?: SELECT COUNT(DISTINCT(CONCAT(contact_firstname,' ',contact_lastname) as contact_name)) as count FROM Contacts GROUP BY contact_ident ORDER BY contact_name; The error returned is: ERROR 1064: You have an error in your SQL

nested aliases in select

Hi all. Can somebody explain to me why the following SELECT doesn't work?: SELECT COUNT(DISTINCT(CONCAT(contact_firstname,' ',contact_lastname) as contact_name)) as count FROM Contacts GROUP BY contact_ident ORDER BY contact_name; The table has: contact_ident contact_firstname contact_lastname