title: INNER JOIN select columns from table2
body: <p>How can I select certain columns from the second and third tables using <strong>INNER JOIN</strong></p>
  
  <pre><code>SELECT 
      *
  FROM
      1_packages_plu AS p
          INNER JOIN
      1_stock as s ON p.fk_products_id = s.fk_products_id
          AND branch = 1
          INNER JOIN
      1_products AS j ON p.fk_products_id = j.id
  WHERE
      fk_packages_id = 54;
  </code></pre>
  
  <p>In the tables <code>1_stock</code> I only want to return the value of <code>stock-repair</code> columns and in the <code>1_products</code> all I need is make,model columns</p>