title: mysql left join question
body: <p>I want make query select all names from table 'a' where from table 'b' i have id_one='3'. id_two is id record from table 
  'a', two records have relation from id_one='3'. How i can make query ?</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `a` (
    `id` int(11) NOT NULL,
    `name` varchar(11) NOT NULL,
    `value` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Zrzut danych tabeli `a`
  --
  
  INSERT INTO `a` (`id`, `name`, `value`) VALUES
  (1, 'lalala', 0),
  (2, 'allalala', 0);
  
  
  
  
  
  
  CREATE TABLE IF NOT EXISTS `b` (
    `id_one` int(11) NOT NULL,
    `id_two` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Zrzut danych tabeli `b`
  --
  
  INSERT INTO `b` (`id_one`, `id_two`) VALUES
  (3, 1),
  (3, 2);
  </code></pre>