title: how to use OR/AND operator together in sql ?
body: <p>I am having issues getting this query to work, i am actually trying to use the OR and AND operator together but can't seem to figure out the problem as to why i am getting this error": <code>"expecting</code>ABSOLUTE' or <code>ACTION' or</code>ADD' or <code>ALL' or</code>ALTER'"`.  Here is my sql code:</p>
  
  <pre><code>SELECT * 
  FROM EDXW ED, TRANSACTION TXN
  WHERE ED.LAM_BK like 'TAR%'
  AND ED.KEY = TXN.KEY
  AND substring(ED.JAM_BK from position('~' in ED.JAM_BK) + 1) = TXN.EBS_ID
  
  (AND ED.CLS_CD IN ('WIS','OP','OPP')
  AND TXN.REV_CD IN ('0360','0361')
  AND TXN.LS_CTR_CD IN ('548000','552000','552500','553000','553500','554000','555000','555500','558000')
  AND ED.SITE_CD = 'X' )
  
  OR
  
  ( ED.ED_CLS_CD IN ('WIS','OP','OPP')
  AND AND TXN.REV_CD IN ('0350','0311')
  AND AND TXN.LS_CTR_CD IN ('548000','558300')
  AND LOC.ED_SITE_CD = 'M')
  
  OR
  
  ( ED.ED_CLS_CD IN ('WIS','OP','OPP')
  AND AND TXN.REV_CD IN ('0350','0311')
  AND AND TXN.LS_CTR_CD IN ('549000','557300')
  AND LOC.ED_SITE_CD IN ('M','K'));
  </code></pre>