title: MySQL - Join View and Table
body: <p>I have a view called "xml_links" which is in the following format</p>
  
  <pre><code>model_number  fk_link            sd_link
  10R46         www.fk.com/10R46   www.sd.com/10R46
  10R47         www.fk.com/10R47   www.sd.com/10R47
  </code></pre>
  
  <p>And a table called "prohub"  </p>
  
  <pre><code>page_url            fk_price      sd_price
  www.fk.com/10R46    $155    
  www.sd.com/10R46                  $161
  www.fk.com/10R47    $117    
  www.sd.com/10R47                  $146
  </code></pre>
  
  <p>I'm trying to join them using the following query and all I get is a <strong>blank table.</strong></p>
  
  <pre><code>select 
      xml_links.model_number, 
      prohub.fk_price, 
      prohub.sd_price
  from 
      xml_links, prohub
  
      where 
          xml_links.fk_link=prohub.page_url
          and 
          xml_links.sd_link=prohub.page_url
  </code></pre>
  
  <p>I'm looking for the following result:</p>
  
  <pre><code>model_number   fk_price   sd_price
  10R46          $155             $161 
  10R47          $117             $146 
  </code></pre>
  
  <p>Thanks for your help</p>