I tried it also with 5.0.24-community-nt and it still didn't work!

Randall Price

Microsoft Implementation Group
Secure Enterprise Computing Initiatives
Virginia Tech Information Technology
1700 Pratt Drive
Blacksburg, VA 24060

Email: Randall.Price@vt.edu
Phone: (540) 231-4396

-----Original Message-----
From: Ahmad Al-Twaijiry [mailto:ahmadt@gmail.com]
Sent: Tuesday, September 19, 2006 10:06 AM
To: Edward Macnaghten
Cc: mysql@lists.mysql.com
Subject: Re: SUM in WHERE

I tried it also with 4.1.21-log and still didn't work !

On 9/19/06, Ahmad Al-Twaijiry <ahmadt@gmail.com> wrote:
> I tried that before and it also doesn't work, is it because I'm using
> mysql version 4.1.19 ?
>
> On 9/19/06, Edward Macnaghten <eddy@edlsystems.com> wrote:
> > Ahmad Al-Twaijiry wrote:
> >
> > > Hi everyone
> > >
> > <snip>
> >
> > > SELECT * FROM tbl_name WHERE SUM(Total)=100 ORDER BY ID
> > >
> > >
> >
> > SELECT ID FROM tbl_name GROUP BY ID HAVING SUM(Total)=100 ORDER BY
ID
> >
>
>
>
> --
>
> Ahmad Fahad AlTwaijiry
>


--

Ahmad Fahad AlTwaijiry

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=Randall.Price@vt.edu