or (field = "x" and (field = "a" or field = "b" or field = "c"));
>
> assuming that you want a record with "x" in field having either
>
> y or z in field or a or b o c in field
>
> HATH
>
> -Original Message-----
> From:
uot;x" in field having either
y or z in field or a or b o c in field
HATH
-Original Message-
From: Petre Agenbag [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 2:49 PM
To: [EMAIL PROTECTED]
Subject: and & or in query
Hi
I would like to issue a logical query as follow:
select
On 12 Sep 2002, at 23:48, Petre Agenbag wrote:
> select * from table where field1 = "x" and ((field2 = "y" or field2 =
> "z") or (field3 = "a" or field3 = "b" or field3 = "c"));
>
> But this syntax is not returning what I expect.
The syntax looks fine (though the inner sets of parentheses aren'
Hi
I would like to issue a logical query as follow:
select * from table where field1 = "x" and ((field2 = "y" or field2 =
"z") or (field3 = "a" or field3 = "b" or field3 = "c"));
But this syntax is not returning what I expect.
Plz help me with syntax
---
