Select question

[greg252]

How can I write this in sql?

select * from table where max>0 && (alpha>10 || beta<10)

It doesn't seem to like ()'s

Thanks.

[mikeatrpi]

|| -> OR, && -> AND could be your problem. Paren's are okay. Also, the word MAX is an SQL keyword; if it is a column name, enclose it in backticks max.

[greg252]

'max' was just an example, the col name is actually max_imp

Thanks.