> > select count(distinct(email)) from subscribes; > > > > But that's not legal. Any thoughts/ideas you all could send in would be > > great. TIA! > > > > Chris Blessing > > [EMAIL PROTECTED] > > http://www.330i.net > >
Try: select count(distinct email) from subscribes; Jay Fesco Magical Mystery Words: database,sql,query,table --------------------------------------------------------------------- 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
