title: How write down to database multiple authors in simple books table?
body: <p>I am wondering how should I save authors (in case where there are more than one author) in simple database.</p>
  
  <p>In case one one book has one authors, everything is easy. The problem is when I want to have table <strong>Books</strong> and want to have possibility of making simple selects and joins with table <strong>Authors</strong> :</p>
  
  <p><strong>Books</strong></p>
  
  <pre><code>| id  | Title | ISBN | Authors? | 
  ---------------------------------
  |     |       |      |          |
  |     |       |      |          |
  </code></pre>
  
  <p><strong>Authors</strong></p>
  
  <pre><code>| id  | Firs Name | Last Name | Short Name | Pseudonym | 
  --------------------------------------------------------
  |     |           |           |            |           |
  |     |           |           |            |           |
  </code></pre>
  
  <p>I know that I can use separate rows with this same ISBN and TITLE, however I wondering is it good idea in case when title can be sometime very large (255-length UTF string/varchar/char).</p>
  
  <p>I know that probably this is very basic problem, so sorry that I have to ask about that :(</p>