Select all records from table a. table b has complementary data but only one record matches table a. I need all of them : <p>I have a MySQL database with 2 tables:</p>

<pre><code>Table A:
id     name   age
123a   John   34
143w   Mark   27
143x   Rony   30

Table B:
id     company     job
143w   Google      developer


I need:
id     name   age  company  job
123a   John   34
143w   Mark   27   Google   developer
143x   Rony   30
</code></pre>

<p>I need a select statement that can extract the result above.<br>
Thanks in advance<br>
Paulo</p>
