SELECT MAX(d), host_position FROM (SELECT host_position, COUNT(host_position) as d FROM sss_host GROUP BY host_position) as e;
am getting and ERROR: Attribute e.host_position must be GROUPed or used in an aggregate function.
Please to advice what could be the problem and how can I rewrite it to work thanks in advance.
Kind regards +-----------------------------------------------------+ | Martin W. Kuria (Mr.) [EMAIL PROTECTED] +----------------------------------------------------+
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
