My mistake. I failed to mention that there are two tables, bar and baz.
And, I found the answer to my question. Thanks everybody.
On 12/2/02 5:52 PM, Adolfo Bello [EMAIL PROTECTED] wrote:
Isn't this sort of impossible?
You are asking for something like a set which contains as an element
the
Isn't this sort of impossible?
You are asking for something like a set which contains as an element
the set itself
WHERE fooId IN (fooId)
Adolfo
-Original Message-
From: Peter Abilla [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 1:43 PM
To: [EMAIL PROTECTED]
Put parentheses around the ..OR.. part (between WHERE and AND) - AND precedes
OR so
Also, use 'IN' instead of a series of 'OR' - this will make the query a lot
faster.
e.g. listings.Area IN ('19','24','25',...)
Vadim.
JD Daniels wrote:
I have this query built from a web form. The form