What version of MySQL are you using?
Rhino
- Original Message -
From: "john sayre" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 07, 2004 6:35 PM
Subject: Why do exists & In fail?
> I'm trying to do some simple in or exists queri
At 15:35 -0700 8/7/04, john sayre wrote:
I'm trying to do some simple in or exists queries, but am getting
syntax error on queries that appear to be correct. If I run the
outside & sub queries alone, not problem. In the In subquery, if I
hardcode a value, ok but this fails:
SELECT * FROM eres
I'm trying to do some simple in or exists queries, but am getting syntax error on
queries that appear to be correct. If I run the outside & sub queries alone, not
problem. In the In subquery, if I hardcode a value, ok but this fails:
SELECT * FROM erestbase WHERE erestbase.id in(SELECT distin