title: how to join multiple table fetch data in wordpress
body: <pre><code>if(isset($_POST['search'])){
      $mls=$_POST['mls_number'];
      $sql = "SELECT * FROM listing_master_residential
       , listing_master_condo 
      , listing_master_commercial  
      INNER JOIN listing_master_residential AS res ON res.Ml_num=Ml_num
      INNER JOIN listing_master_condo AS con ON con.Ml_num=Ml_num
      INNER JOIN listing_master_commercial AS com ON com.Ml_num=Ml_num
       WHERE Ml_num='$mls'";
      $result = $wpdb-&gt;get_results($sql) or die(mysql_error());
      foreach( $result as $row){
          echo $row-&gt;Lot_code."&lt;br/&gt;";
          echo $row-&gt;Ml_num."&lt;br/&gt;";
          echo $row-&gt;Acres;
          echo $row-&gt;Addr."&lt;br/&gt;";
          echo $row-&gt;Bath_tot;
          echo $row-&gt;Br;
          echo $row-&gt;Br_plus;
      }
  
  }
  
   }
  </code></pre>
  
  <p>please check my code  they show an error code </p>
  
  <p>Column 'Ml_num' in where clause is ambiguous</p>
  
  <p>thank you in advance
  please help me .. where i am wrong 
  ?</p>