title: Create view statement returns an empty result set
body: <p>I have a table called matchresults which has five columns named mresultid, playerid, seasonmatchid, rank, ratingsearned </p>
  
  <p>mresultid is the primary key and playerid and seasonmatchid are foreign keys</p>
  
  <p>The problem is that when I try to create a view on this table:</p>
  
  <pre><code>DROP VIEW IF EXISTS matchresults_view;
  CREATE  VIEW matchresults_view AS 
  select mresultid, playerid, seasonmatchid 
  from matchresults
  where id = 8 ;
  </code></pre>
  
  <p>The query runs but it says mysql returned an empty result set. This is not true as I should be having two tuples in the result set.</p>
  
  <p>What is wrong with the query?</p>