title: Can I join two tables in MYSQL and create a new table
body: <p>I want to make a new table after joining this two tables if it is possible</p>
  
  <pre><code>SELECT * FROM tablepeople
  JOIN tableinfo
  ON tablepeople.id = tableinfo.ctrlid
  </code></pre>