title: Problem with joining to an empty table
body: <p>I use the following query:</p>
  
  <pre><code>select * from A LEFT JOIN B on ( A.t_id != B.t_id)
  </code></pre>
  
  <p>to get all the records in A that are not in B.</p>
  
  <p>The results are fine except when table B is completely empty, but then I do not get any records, even from table A.</p>
  
  <h1>Later</h1>
  
  <p><strong>It won't work yet!</strong></p>
  
  <h3>Table structure for T1</h3>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `T1` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `t_id` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3;
  </code></pre>
  
  <h3>Dumping data for table <code>T1</code></h3>
  
  <pre><code>INSERT INTO `T1` (`id`, `title`, `t_id`) VALUES
  (1, 'apple', 1),
  (2, 'orange', 2);
  </code></pre>
  
  <h3>Table structure for table <code>T2</code></h3>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `T2` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `t_id` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2;
  </code></pre>
  
  <h3>Dumping data for table <code>T2</code></h3>
  
  <pre><code>INSERT INTO `T2` (`id`, `title`, `t_id`) VALUES
  (1, 'dad', 2);
  </code></pre>
  
  <h3>Operations</h3>
  
  <p>Now I want to get all records in T1 that do not have a corresponding records in T2.</p>
  
  <p>I try</p>
  
  <pre><code>SELECT *
  FROM T1
  LEFT OUTER JOIN T2 ON T1.t_id != T2.t_id
  </code></pre>
  
  <p>and it won't work.</p>