Sorry, let me try and explain a bit better:
Table:
Field1 Field2 Field3
annetypist good
betty reception fair
sandy typist excellent
elise pa bad
danareception excellent
cindy
I would write this in this way:
select * from table where (field = "x" and ($field = "y" or field = "z"))
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
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'