Home -> Usenet -> comp.databases.theory -> SQL ... Order of operations with Logical Operators

SQL ... Order of operations with Logical Operators

From: FRAN <fran_beta_at_hotmail.com>
Date: 19 Jul 2006 18:19:46 -0700
Message-ID: <1153358386.027419.62340_at_i3g2000cwc.googlegroups.com> 





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 Thu Jul 20 2006 - 03:19:46 CEST












Original text of this message