Have you tried
WHERE ytd_sales >= 4095 AND ytd_sales <=12000;
Also, you may try adding ( ).
They sometimes help.
Thanks
Emery
----- Original Message -----
From: "Nitin" <[EMAIL PROTECTED]>
To: "Jim Bartram" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 08:30
Subject: Re: Adapting a Select statement to MySQL
> query seems perfect, what error is this giving?
>
> Nitin
>
> ----- Original Message -----
> From: "Jim Bartram" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, November 04, 2003 10:07 AM
> Subject: Adapting a Select statement to MySQL
>
>
> > I've got the following select statement that is defeating me!
> >
> > select title_id, ytd_sales from titles
> > where ytd_sales between 4095 and 12000;
> >
> > The WHERE clause is not working... How should this be done in MySQL?
> >
> > Thanks for any help,
> >
> > -Jim
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
