title: Left Join Duplicate Column
body: <p>I have two tables in a database. One is for products and the other is for product images. I'm joining the tables so that I can get the product images and info with one query:</p>
  
  <pre><code>SELECT * 
  from items left join images 
       on items.item_id = images.item_id and 
          items.display_items = '1' and items.active = '1' 
  order by items.item_year desc, items.fullname desc, images.position asc
  </code></pre>
  
  <p>I noticed, however, that all of the products weren't showing up. Some of the products don't have any images and those were the ones not appearing. I ran my query in Sequel Pro and saw that the column <code>item_id</code> was appearing twice, once with the id and once as <code>NULL</code>. How can I fix my query to get all of the products?</p>