title: SQL oracle where clause
body: <pre><code>SELECT *
  FROM PERSONNE
  WHERE PERSONNE.NO_PERSONNE = GENEALOGIE.NO_PERSONNE
    AND GENEALOGIE.TYPE_EVENEMENT_GEN = 'Baptême'
    AND GENEALOGIE.LIEU_EVENEMENT_GEN != 'Ste-Lubie'
    AND GENEALOGIE.TYPE_EVENEMENT_GEN = 'Mariage'
    AND GENEALOGIE.LIEU_EVENEMENT_GEN = 'Ste-Lubie';
  </code></pre>
  
  <p>I would love to do something like that.</p>
  
  <p>select where the person has been married in Ste-Lubie but not 'Baptême' in Ste-Lubie.</p>