title: SQL unknown column when doing join
body: <p>I have been getting an error "Unknown column 'guests_guest.id' in 'field list'" when i try to run the following:</p>
  
  <pre><code>SELECT guests_guest.id
  FROM `guests_guest` full join
  guests_guest_group
  on guests_guest.id=guests_guest_group.guest_id
  </code></pre>
  
  <p>All the column&amp; table names are correct. in fact, running just</p>
  
  <pre><code>SELECT guests_guest.id
  FROM `guests_guest`
  </code></pre>
  
  <p>works just fine. I suspect there is a syntax issue I am missing. what am I doing wrong?</p>