title: MySQL - Only populating from one table dependent on value
body: <p>Sorry haven't used SQL in some time. I have three tables about superheros. I want to get the superhero name and retreive a tv name from either Marvel or DC dependent on the results. However the query is populating both columns when retrieving the information when I should just have one entry per name. My View is:</p>
  
  <pre><code>CREATE VIEW `herotelly` AS 
  SELECT distinct(a.Name), b.Title as showname, c.Title
  FROM superheroes a, marveltv b, dctv c
  WHERE a.Name = b.Superhero or a.Name = c.Superhero;
  </code></pre>
  
  <p>However the result is</p>
  
  <pre><code>"Superman"  "Spidey Super Stories"  "Adventures of Superman"   
  "Batman"    "Spidey Super Stories"  "Batman"      
  "Catwoman"  "Spidey Super Stories"  "Batman" 
  "Robin"     "Spidey Super Stories"  "Batman"
  </code></pre>
  
  <p>But I only want one result for example in the first row I just want superman, with the second column empty and then the result in the third column.</p>
  
  <p>Any help is much appreciated.</p>
  
  <p>Neil. </p>