title: JOIN using sqlx causes 'missing destination name'
body: <p>I have this query that works fine on mysql and return the intended result, but <a href="https://github.com/jmoiron/sqlx" rel="nofollow noreferrer">sqlx</a> has difficulty to handle it:</p>
  
  <pre><code>var jokes []model.Joke
  err := shared.Dbmap.Select(&amp;jokes, "SELECT * FROM joke INNER JOIN jokevote ON joke.id=jokevote.joke_id AND jokevote.vote=? AND joke.user_id=?", 1, userId)
  if err != nil {
      log.Println(err)
  }
  </code></pre>
  
  <p>At runtime, I get no result but this error message in terminal:</p>
  
  <blockquote>
    <p>missing destination name joke_id</p>
  </blockquote>
  
  <p>I don't have this issue when querying a single table. </p>
  
  <p>So I'm wondering what is wrong here and how to fix it?</p>
  
  <p><strong>UPDATE:</strong> Here are the structs:</p>
  
  <pre><code>type Joke struct {
      ID         int       `db:"id" json:"id"`
      UserID     int       `db:"user_id" json:"user_id"`
      Title      string    `db:"title" json:"title"`
      Content    string    `db:"content" json:"content"`
  
  ...
  }
  
  type JokeVote struct {
      ID     int `db:"id" json:"id"`
      JokeID int `db:"joke_id" json:"joke_id"`
      UserID int `db:"user_id" json:"user_id"`
      Vote   int `db:"vote" json:"vote"`
  }
  </code></pre>