title: Is there a better way than using 2 SELECT?
body: <p>Say that I have 2 tables, one with entries of films that an user likes and an other with events that an user has gone. Each table has a column for knowing the user. Something like:</p>
  
  <p>Table Films:</p>
  
  <pre><code>id | iduser | film | number of watches | note ....
  </code></pre>
  
  <p>Table events:</p>
  
  <pre><code>id | iduser | event | date | ....
  </code></pre>
  
  <p>both iduser are connected with a relation to a table with other information of the user.</p>
  
  <p>If I want to select some columns from table films and others from table events with the same iduser, is there a better way than 2 SELECT? I say this because each select has diferent number of rows so UNION gives me an error and join gives me like:</p>
  
  <p><strong>EDIT</strong></p>
  
  <pre><code>FILM   | NOTE |     EVENT     | DATE
  -----------------------------------------
  tlor   |  9  | going to park  | 20/7/12
  tlor   |  9  | eat a sandwich | 5/9/10
  B film |  7  | going to park  | 20/7/12
  B film |  7  | eat a sandwich | 5/9/10
  </code></pre>
  
  <p><strong>EDIT 2</strong></p>
  
  <p>I say only a select because I think is the faster way but if there's a faster way, please let me know it.</p>