title: Joining 2 tables in SELECT(MYSQL/PHP)
body: <p>I have these two tables. The connecting "key"  is conID which is included in both tables.
  So now i would like to write select statement which would give me something like this:</p>
  
  <p>John Smith dairy22 Texas 4000 smth4</p>
  
  <p>Mike Situation glenn32 Jersey 1000 smth1
  ...</p>
  
  <p><strong>> table "people":</strong></p>
  
  <pre><code>NUM   Name lastName  address    conID
  -----------------------------------------
    1    John  Smith     dairy22   Texas
    2    Mike  Situation glenn32   Jersey
    3    Duke  Nukem     haris48   NYork
    4    Queen Lisa      court84   London
  </code></pre>
  
  <p><strong>> table "countries"</strong></p>
  
  <pre><code>conID   postNum   region
  -------------------------
  Jersey  1000      smth1
  NYork   2000      smth2
  London  3000      smth3
  Texas   4000      smth4
  </code></pre>
  
  <p><strong>! -> NUM is AUTO INCREMENT primary key, which i dont want it the output if possible.</strong></p>
  
  <p>Thanks for help in advance :))</p>