Re: Seeking Syntax Assistance

2005-05-13 Thread SGreen
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 05/13/2005 12:05:05 PM: > Hello, > I am accustomed to Oracle query syntax, and I am having trouble with > this following query which uses the IN. I am running mysql ( Ver 12. > 21 Distrib 4.0.15, for Win95/Win98 (i32) ) which does not support the IN. >

Re: Seeking Syntax Assistance

2005-05-13 Thread Eric Bergen
Sorry, mysql doesn't support sub queries until version 4.1 -Eric Scott Purcell wrote: Hello, I am accustomed to Oracle query syntax, and I am having trouble with this following query which uses the IN. I am running mysql ( Ver 12.21 Distrib 4.0.15, for Win95/Win98 (i32) ) which does not support t

Seeking Syntax Assistance

2005-05-13 Thread Scott Purcell
Hello, I am accustomed to Oracle query syntax, and I am having trouble with this following query which uses the IN. I am running mysql ( Ver 12.21 Distrib 4.0.15, for Win95/Win98 (i32) ) which does not support the IN. How do I rewrite the below query to function? Basically what I have is three