title: mysql: select all rows from 2 different tables
body: <p>i have 2 tables in mysql dabase with different row numbers and different column, so i want to display all results together</p>
  
  <p><strong>table_one:</strong></p>
  
  <pre><code>id, name, surname, phone, email
  </code></pre>
  
  <p><strong>table_two:</strong></p>
  
  <pre><code>id,name,city,phone,website
  </code></pre>
  
  <p>so table_one has 30 rows and table_two has 10 rows
  how can i show all together</p>
  
  <pre><code>id,name,surname,city,phone,email,website
  </code></pre>
  
  <p>Tried this but is not working</p>
  
  <pre><code>SELECT * FROM table_one UNION ALL SELECT * FROM table_two ;
  </code></pre>