title: One statement to select data from two MySQL tables. Show name instead of/by ID
body: <p>I have 2 tables </p>
  
  <p>The table .issues looks like this:</p>
  
  <pre><code>id tracker_id project_id    
  22       1       218
  </code></pre>
  
  <p>In the second table .trackers:</p>
  
  <pre><code>id    name    
  1     Error
  </code></pre>
  
  <p>Is it possible to make one Select request to receive back the result with names of trackers instead of/with their ids? I need it to simplify the Java Request.</p>
  
  <p>I want to get smth like this:</p>
  
  <pre><code> id  (tracker_id) project_id tracker_name
   22  (1)           218        Error
  </code></pre>
  
  <p>I tried this, but I know it doesn't make much sense: </p>
  
  <pre><code>Statement stmt1 = conn.createStatement();
  ResultSet ticketsRows = stmt1.executeQuery("SELECT * FROM issues 
  WHERE tracker_id IN (SELECT id FROM trackers)");
  </code></pre>