SQL ... Order of operations with Logical Operators

Can anyone advise how operations are treated when AND and OR are combined?

eg

WHERE: Condition 1 > X AND Condition 2 < Y OR Condition 3 = Z

Would the result of this query be to return results that

1. Satisfied Condition 1 AND Condition 2 or alternatively, Condition 3 regarless of Conditions 1 AND 2

OR

b) Condition 1 AND Condition 2 OR Condition 1 AND Condition 3

Thanks

Fran Received on Wed Jul 19 2006 - 20:19:46 CDT