PostgresSQL combining tables <p>I am a little confused about merging one table into another. My two tables looks like so:</p> <pre><code>Table A Table B id | name | likes | email | username id | name | email | username 1 | joe | 3 | null | null 1 | ben | a@co.co | user Result: Table A id | name | likes | email | username 1 | joe | 3 | null | null 2 | ben | null | a@co.co | user </code></pre> <p>My issue is that I do not want to overwrite the properties that are in the Table A. Is this a simple <code>UNION</code>?</p>