From: Martin Ramsch Date: March 20 1999 6:52pm Subject: Re: Help with query, plz List-Archive: http://lists.mysql.com/mysql/695 Message-Id: <19990320195255.B28496@forwiss.uni-passau.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii On Sa, 1999-03-20 12:49:40 -0600, Ed Carp wrote: [...] > This is really funny, especially because... > > > SELECT DISTINCT field FROM table; > > > ...isn't right either! It gives a table of results, not the count, > which is what the original poster wanted. Did you actually read what I wrote? I said, that after this query one should get the number of results. I didn't say, that one should use the result itself. > Sorry, but thanks for playing. You're welcome. :) Regards, Martin -- Martin Ramsch PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26 E4 EC 80 58 7B 31 3A D7