Re: Query Trouble!

2005-10-03 Thread Barry
- Original Message - From: [EMAIL PROTECTED] To: Barry Cc: mysql@lists.mysql.com Sent: Monday, October 03, 2005 9:49 PM Subject: Re: Query Trouble! "Barry" <[EMAIL PROTECTED]> wrote on 10/03/2005 04:38:48 PM: > I'm new to MySQL and am usi

Re: Query Trouble!

2005-10-03 Thread SGreen
"Barry" <[EMAIL PROTECTED]> wrote on 10/03/2005 04:38:48 PM: > I'm new to MySQL and am using version 4-1-12a on my development > machine locally this query works just fine: > > SELECT * FROM actor > WHERE id IN > ( SELECT id FROM episode_cast > WHERE episode_number =001) >

Query Trouble!

2005-10-03 Thread Barry
I'm new to MySQL and am using version 4-1-12a on my development machine locally this query works just fine: SELECT * FROM actor WHERE id IN ( SELECT id FROM episode_cast WHERE episode_number =001) but when I try to run it from the web server which is running version 4.0.24