title: Problem reading from 3 tables in mysql
body: <p>What do I do, I need to fetch data from 3 tables in mysql, here is my current query. All of the tables contain the IDNO which has 03A45 number. But this query isnt returning any results:</p>
  
  <pre><code>SELECT * 
    FROM father, mother, parents 
   WHERE father.IDNO=mother.IDNO=parents.IDNO 
     AND mother.IDNO='03A45' 
     AND father.IDNO='03A45' 
     AND parents.IDNO='03A45'
  </code></pre>
  
  <p>What would be the correct query for this?<br>
  All of the tables have the IDNO as primary key.</p>