title: the whole data from tables is not coming via join query in mysql
body: <p>i'm working with php mysql and there are 12 tables which contains student informations.There are 3 main table First table is registration, second is demandraft and third is creditcard.The demandraft table contains all the creditcard table fields but as empty. now i want to get the whole data from these three tables to generate my xls file but coz there are  empty fields of creditcard table in demandraft table so unable to fetch the whole records from all 3 tables. there is stuid field common in all 3 tables.</p>
  
  <p>Here is my join query for that:</p>
  
  <pre><code>$sql = "select * from  registration 
          join programme on registration.id=programme.stuid 
          join family on registration.id=family.stuid 
          join address on registration.id=address.stuid 
          join education on registration.id=education.stuid 
          join extradetail on registration.id=extradetail.stuid 
          join workexperience on registration.id=workexperience.stuid 
          join demanddraft on registration.id=demanddraft.stuid 
          join payonline on registration.id=payonline.stuid 
          where (DATE(registration.createddate)&gt;='".$term1."' 
          AND DATE(registration.createddate)&lt;='".$term2."')";
  </code></pre>