title: How to join two tables ids with auto increment
body: <p>How can i join two tables ids both are <code>AUTO_INCREMENT</code> i need result like this i am showing  example below. what i want.</p>
  
  <pre><code>Table1                 |                Table2
  -----------------------|-----------------------
  userid | name | f_name |userid | work | study 
  -----------------------|-----------------------
  1      |  ali |  amjad |1      | yes  | no
  -----------------------|-----------------------
  2      |  aff | mff    |2      |no    |yes
  </code></pre>
  
  <p><code>Table1</code> and <code>Table2</code> userid should be same. </p>