title: mysql join respect to a column
body: <p>I got two mysql table like this</p>
  
  <pre><code>CREATE  TABLE IF NOT EXISTS tbl1 (
  `id` INTEGER(2) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT ,
  `name` VARCHAR(20) NOT NULL
  ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
  
  CREATE  TABLE IF NOT EXISTS tbl2 (
  `tbl_id` INTEGER(2) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT ,
  `id2` INTEGER(2) UNSIGNED NOT NULL ,
  `email` VARCHAR(20) NOT NULL ,
  FOREIGN KEY (`id2`) REFERENCES tbl1(`id`)
  ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
  </code></pre>
  
  <p>Here is example data in tbl1</p>
  
  <pre><code>1   hello
  2   world
  3   happy
  4   end
  </code></pre>
  
  <p>and example data in tbl2</p>
  
  <pre><code>2   1   me@mail
  3   2   my@mail
  4   4   you@mail
  </code></pre>
  
  <p>now I want to select name and email joining two table. Here is the sql</p>
  
  <pre><code>select name,email from tbl1 t1,tbl2 t2 where t2.id2 = t1.id;
  </code></pre>
  
  <p>with it i'm getting </p>
  
  <pre><code>hello   me@mail
  world   my@mail
  end     you@mail
  </code></pre>
  
  <p>but I want all row from tbl1</p>
  
  <pre><code>hello   me@mail
  world   my@mail
  happy   null or nothing or 0
  end     you@mail
  </code></pre>
  
  <p>here i am stuck. any help will be appreciated.
  thanks in advance.</p>