title: LEFT JOIN on PHP
body: <p>I have tried the same code below on my c# app and it works fine, but when i tried the same code on php with the tweak of instead of column number on c# i replaced it with column name but the result is different.</p>
  
  <pre><code>$sql ="SELECT 
          `adexposure`.`symbol`, 
          `adexposure`.`netvolume`, 
          `fxexposure`.`netvolume`, 
          `adexposure`.`lastupdate` 
      FROM `adexposure` 
      LEFT JOIN `fxexposure` ON `adexposure`.`symbol` = `fxexposure`.`symbol`";
  
  $result = $conn-&gt;query($sql);
  if($result-&gt;num_rows&gt;0)
  {
              echo "&lt;table&gt;";
              echo "&lt;tr&gt;";
              echo "&lt;th&gt;Symbol&lt;/th&gt;";
              echo "&lt;th&gt;Net Volume A&lt;/th&gt;";
              echo "&lt;th&gt;Net Volume B&lt;/th&gt;";
              echo "&lt;th&gt;Last Update&lt;/th&gt;";
              echo "&lt;/tr&gt;";
              while($row = $result-&gt;fetch_assoc())
              {
                              echo "&lt;tr&gt;";
                              echo "&lt;td&gt;" .$row["symbol"]."&lt;/td&gt;";
                              echo "&lt;td&gt;" .$row["netvolume"]."&lt;/td&gt;";
                              echo "&lt;td&gt;" .$row["netvolume"]."&lt;/td&gt;";
                              echo "&lt;td&gt;" .$row["lastupdate"]."&lt;/td&gt;";
                              echo "&lt;/tr&gt;";                     
              }
              echo "&lt;/table&gt;";
   }
   else
   {
              echo "0 results";
   }
  </code></pre>
  
  <p>Result should be:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;table border=1&gt;
      &lt;tr&gt;
      &lt;th&gt;Symbol&lt;/th&gt;
      &lt;th&gt;Net Volume A&lt;/th&gt;
      &lt;th&gt;Net Volume B&lt;/th&gt;
      &lt;th&gt;Last Update&lt;/th&gt;
      &lt;/th&gt;
      &lt;/tr&gt;
      &lt;tr&gt;
      &lt;td&gt;BITCOIN&lt;/td&gt;
      &lt;td&gt;2.5&lt;/td&gt;
      &lt;td&gt;3.5&lt;/td&gt;
      &lt;td&gt;2018.02.05 10:44&lt;/td&gt;
      &lt;/tr&gt;
      &lt;tr&gt;
      &lt;td&gt;LITECOIN&lt;/td&gt;
      &lt;td&gt;1.5&lt;/td&gt;
      &lt;td&gt;5.5&lt;/td&gt;
      &lt;td&gt;2018.02.05 10:44&lt;/td&gt;
      &lt;/tr&gt;
      &lt;tr&gt;
      &lt;td&gt;HASHCOIN&lt;/td&gt;
      &lt;td&gt;0.5&lt;/td&gt;
      &lt;td&gt;0.5&lt;/td&gt;
      &lt;td&gt;2018.02.05 10:44&lt;/td&gt;
      &lt;/tr&gt;
      &lt;/table&gt;</code></pre>
  </div>
  </div>
  </p>
  
  <p>but thats not the case.
  The result shows both net volume of fxexposure.netvolume.</p>
  
  <p>I hope you can help me with this.</p>
  
  <p>Thanks...</p>