title: mysql select alias not working
body: <p>Im having trouble with my select statement, when run title_two and author_two are not being filled properly by the next title value. Instead they print out the same as b.title and b.author. I've tried declaring them as</p>
  
  <pre><code> `B.title AS title_two`.   
  
    SELECT R.bookone, B.title, B.author,
       R.booktwo, B.title title_two, B.author author_two, 
      R.relation, R.relationlike, R.relationdislike 
      FROM relationships R 
      INNER JOIN books B ON R.bookone = B.bookid;
  </code></pre>
  
  <p>there are two tables </p>
  
  <p>relationships which has the following - relationshipid, bookone, booktwo, relation, relationlike, relationdislike</p>
  
  <p>then books which is bookid, title, author, publisher </p>
  
  <p>bookone and booktwo are foreign keys referencing bookid what im trying to acheive is have it so that when a user clicks a link itll come up with every relationship that book has with other books</p>