Re: Adapting a Select statement to MySQL

2003-11-04 Thread Jim Bartram
ROTECTED]> 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 b

Re: Adapting a Select statement to MySQL

2003-11-04 Thread Director General: NEFACOMP
]> 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]>

Re: Adapting a Select statement to MySQL

2003-11-03 Thread Nitin
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 foll

Adapting a Select statement to MySQL

2003-11-03 Thread Jim Bartram
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://l