title: SQL join multiple Tables
body: <p>I'm trying to join 3 tables into 1. But I am getting a "Could not be bound" Error message.</p>
  
  <p>As I'm new to SQL,  I am not sure if its error in my code or if I have set the Table relationships up wrong?</p>
  
  <p>I have a picture of my primary and foreign keys here:
  <a href="http://crystalise.tw/shadow/public.php?service=files&amp;t=b036d2b2516576b27532b947dfb96293" rel="nofollow noreferrer">http://crystalise.tw/shadow/public.php?service=files&amp;t=b036d2b2516576b27532b947dfb96293</a></p>
  
  <p>Here is my SQL code I play with.
   I have managed to get the first attempt using only 2 tables to work fine.  But I get problems when I try to implement the 3rd table.   What should I take a closer look on this time ?</p>
  
  <pre><code>--
  --SELECT Artists.nameArtist, Albums.nameAlbum 
  --  FROM Artists
  --  INNER JOIN Albums 
  --  ON Artists.idArtist = Albums.idArtist
  --  ORDER BY nameAlbum 
  --  
  
  
  
  SELECT Artists.nameArtist, Albums.nameAlbum, Songs.nameSong 
    FROM Artists
    JOIN Songs
    ON Artists.idArtist = Albums.idArtist
  
  JOIN Albums
    ON Artists.idArtist = Songs.idArtist
  </code></pre>