Join query with not equal
<p>I want to get all unpaid male customers those who are not in any plan</p>

<pre><code>SELECT cr.id, cr.type FROM mydb.customer cr 
JOIN mydb.plan1 p1 on cr.id != p1.id 
JOIN mydb.plan2 p2 on cr.id != p2.id 
JOIN mydb.plan3 p3 on cr.id != p3.id 
WHERE cr.type = 'male'
</code></pre>

<p>is this query correct?</p>