title: oracle sql error- missing right parenthesis
body: <p>I read almost everything similar questions to mine and i didn't come up with the answer.</p>
  
  <p>I've written a query for Horses Database.
  There i want to make a list with horses that never finished first in any of their participations in all meetings they have participated in.My query is:</p>
  
  <pre><code>SELECT H1.Horse_ID,H1.H_compressed_name
  
  FROM Horse H1
  
  WHERE NOT EXISTS
  
        ((SELECT P1.Part_ID
  
         FROM participation P1)
  
         EXCEPT(  --line *
  
            SELECT P2.Part_ID
  
            FROM participation P2,Horse H2
  
            WHERE P2.H_ID=H2.Horse_ID AND P1.Part_ID=P2.Part_ID  
                  AND H1.Horse_ID=H2.Horse_ID));
  </code></pre>
  
  <p>I get this error:</p>
  
  <pre><code>SQL Error: ORA-00907: missing right parenthesis 
  00907. 00000 -  "missing right parenthesis" 
  *Cause:     
  *Action: 
  </code></pre>
  
  <p>in line *.</p>
  
  <p>But im not if sure if the problem is a missing right parenthesis indeed.Any help pls??</p>