How do I find fields unique to data in other fields?
<p>To generalise, I have a database with a similar structure to the following:</p>

<hr>

<pre><code>CustomerDatabase
ProductID  | ProductName | CustomerID | Gender |
008100     | Laptop      | 1          | Male   |
008101     | Desktop     | 2          | Female |
008100     | Laptop      | 3          | Female |
008102     | Printer     | 4          | Male   |
008101     | Desktop     | 5          | Female |
</code></pre>

<p>What statement could I run to display product IDs that have only been purchased by a particular gender and not the other?</p>

<p>An Example result would look like:</p>

<pre><code>ProductID | Gender | CustomerID|
008101    | Female | 2         |
008101    | Female | 5         |
</code></pre>

<p>because The product "008101" was only purchased by females and not males.</p>

<p>Thanks in advance.</p>