title: sql join two table
body: <pre><code>TABLE A &gt;&gt;
  uid name
  1   test1
  2   test2
  3   test3
  4   test4
  
  TABLE B &gt;&gt;
  uid address
  1   address1
  2   address2
  4   address3
  
  RESULT
  1   test1   address1
  2   test2   address2
  3   test3
  4   test4   address3
  </code></pre>
  
  <p>Can anyone show me how to write a query and fetch the result as above, Thanks very much!
  i have tried join, left and right join. all result nothing.</p>