Dear all! Thanks a lot for attention. I solve my problem using an alias to COUNT. Regards for all! ***********Paulino Michelazzo Reply*********** >Hi all! > >I need to get the "count" field in a select instruction like this: > >(from My-SQL help) > >SELECT owner, COUNT(*) FROM pet GROUP BY owner >+--------+----------+ >| owner | COUNT(*) | >+--------+----------+ >| Benny | 2 | >| Diane | 2 | >| Gwen | 3 | >| Harold | 2 | >+--------+----------+ > >I use Cold Fusion with My-SQL and i can get the owner field easy, but the >count field IS NOT a really field > >Anybody can help me? b ************************************************************ Paulino Michelazzo - IT Adviser http://www.michelazzo.com.br [EMAIL PROTECTED] - ICQ: 2911392 BOX 31210 - SP/SP - CP: 01309-970 - Brazil/SA --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
