title: How to select tables that have different columns except for an id
body: <p>I'm running MySQL 5.1.61 and my MyISAM tables are set up as</p>
  
  <pre><code>objects:
  id | owner | created_date
  ---------------------------------
  1  | xxx   | xxxxxxxx
  2  | xxx   | xxxxxxxx
  
  photos:
  id | width | height | url
  -------------------------
  2  | 800   | 480    | http://somewhere.com/photo.jpeg
  
  posts:
  id | message
  ------------
  1  | Hello, world!
  2  | Goodbye!
  </code></pre>
  
  <p>I want something like</p>
  
  <pre><code>SELECT * FROM objects LEFT JOIN posts ON objects.id=posts.id LEFT JOIN photos ON objects.id=photos.id
  </code></pre>
  
  <p>but running this query gives me</p>
  
  <pre><code>id | owner | created_date | id | message | id   | width | height | url
  ----------------------------------------------------------------------
  1  | xxx   | xxxxxxxx     | 1  | Hell... | NULL | NULL  | NULL   | NULL
  2  | xxx   | xxxxxxxx     | 2  | Good... | 2    | 800   | 480    | http://som....
  </code></pre>
  
  <p>Which is what I want, except for the duplicate id columns.</p>
  
  <p>Short of spelling out all the columns I want which would be tedious but one time only, how can I get rid of those duplicate id columns?  I only want one column since they're all going to have the same value anyway.</p>
  
  <p>Also note that I may add more tables, such as 'video', 'url', so its not just these two tables.</p>
  
  <p>Thank you.</p>