title: How to create a Left Join in Jinzhu GORM
body: <p>I can not create a simple query with a left join in jinzhu GORM (MySQL database)</p>
  
  <p>These are my structs:</p>
  
  <pre><code>type Prop struct {
      ID          uint   
      Status      Status 
      StatusID    uint
      Name        string 
  }
  
  type Status struct {
      ID   uint   
      Name string
  }
  </code></pre>
  
  <p>Prop has a foreign key to Status</p>
  
  <p>The SQL query i would like to perform is:</p>
  
  <pre><code>SELECT * from prop LEFT JOIN status ON prop.status_id = status.id
  </code></pre>
  
  <p>So i would retrieve all records from prop table joined with status table</p>
  
  <p>I tried:</p>
  
  <pre><code>db.Find(&amp;prop).Related(&amp;status) 
  </code></pre>
  
  <p>but no Success. Anyone has some advice? Thanks in advance</p>