Thankfully we're upgrading in the very near future (this weekend) so I can take advantage of this and other changes (like temp table memory issues!).
Thanks again for everyone's help! -Chris -----Original Message----- From: Jay Fesco [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 10:53 AM To: Chris Blessing; [EMAIL PROTECTED] Subject: RE: general sql question > > I have a feeling this has something to do with running 3.22 > instead of 3.23. > ;) > > Whadya think? > Oops... Yup, according to page 57 of Mr. Dubois' MySQL COUNT() combined with DISTINCT is a 3.23.2+ feature... I'll be interested to see the proper answer to this... (besides 'upgrade' - I'm running 3.22 on one of my servers and don't intend to upgrade anytime soon because of complications with ChiliSoft...) 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
