title: How to call back a parents name from child table?
body: <p>I have two tables as follows:</p>
  
  <p>games</p>
  
  <pre><code>id | game_name | console_id
      1     God of War     1
      2     Zelda          3
      3     Sonic          4
  </code></pre>
  
  <p>consoles</p>
  
  <pre><code>id | console_name 
  1    PS4
  2    Xbox
  3    Switch
  4    Mega Drive
  </code></pre>
  
  <p>I've linked them via the Designer view so when I go to insert a name game (I'm doing this via the phpMyAdmin control panel) as soon as I click on "console_id" it gives me a drop down of 1 - PS4, 2 - Xbox and so on. So the games table can now read from consoles table no problem so I think I've got everything correct from that side of things.</p>
  
  <p>Now I can run this code</p>
  
  <blockquote>
    <p>SELECT id, game_name, console_id FROM games</p>
  </blockquote>
  
  <p>and I will get the output</p>
  
  <blockquote>
    <p>1 - God of war - 1</p>
  </blockquote>
  
  <p>What I would like to do is something like this:</p>
  
  <blockquote>
    <p>SELECT id, game_name, console_id.<strong>console_name</strong> FROM games</p>
  </blockquote>
  
  <p>So instead of it saying God of war is on console ID 1, it says its on console.name PS4.</p>
  
  <p>How can I do it, as I thought by linking the tables it would allow me to do it.</p>