PostgreSQL: How to add Column from other table in select statement?
<p>I'm trying to select a column from another table like I used to do in <strong>MSSQL</strong>:</p>

<pre><code> select * , Date = (select top 1 Date from [dbo].TableB where status = 1 order by Date desc)
 from [dbo].TableA
</code></pre>

<p><strong>How can I do that in PostgreSQL?</strong></p>

<p>Additional sample data:</p>

<blockquote>
  <p>TableA</p>
</blockquote>

<pre><code>Names

Richards
Marcos
Luke
Matthew
John    
</code></pre>

<blockquote>
  <p>TableB</p>
</blockquote>

<pre><code>Date        Status
2016-01-01  1
2016-01-02  0
2016-01-03  1
2016-01-04  1
2016-01-05  1 
</code></pre>

<p>Expected Output:</p>

<pre><code>Name        Date
Richards    2016-01-02
Marcos      2016-01-02
Luke        2016-01-02
Matthew     2016-01-02
John        2016-01-02
</code></pre>

<p>Thanks!</p>