title: SQL joins confusion
body: <p>what is problem in this join???
  The console says</p>
  
  <pre><code>Error Code: 1051
  Unknown table 'invlabtes'
  
  
  SELECT invlabtes.*, invgatepass.BuiltySupp FROM invlabtes FULL JOIN invgatepass ON(invlabtes.GatePassNO=invgatepass.InwardNo AND invlabtes.GatePassDate=invgatepass.EntryDate AND invlabtes.VehicleNo=invgatepass.VehicleNo) WHERE  invlabtes.Code='*****'
  </code></pre>
  
  <p>If I replace the Full join with inner join then the query returns an entry.</p>
  
  <p>All I want is to fetch data from invlabtes table based on invlabtes.Code even if the join condition fails and invgatepass has no matching builtySupp </p>