这个sql语句 where条件式如何写?

[for123]

"当字段field1等于a 且field2 等于b或c且field3等于d或e"
sql="where fields1='a' and field2='b' or field2='c'
sql=sql & "and field3='d' or field3='e' "
这是不对的。正确的写法是?

[beta]

???是在出题吗？
where field1=a and (field2=b or field2=c) and (field3=d or field3=e)

[蝈蝈俊]

sql="where fields1='a' and (field2='b' or field2='c' )"
sql=sql & "and (field3='d' or field3='e') "

[hu_zy]

而且你最后没有分号！

[skt642]

77591关注！