Re: Oracle outer join porting question - Mailing list pgsql-sql

On 15 Jan 2003 at 16:40, Tambet Matiisen wrote:

> Try this:
> 
> SELECT doc.id,doc.title,sub.user_id,sub.operation
>   FROM document doc LEFT OUTER JOIN document_subscription sub
>   ON sub.document_id = doc.id AND sub.user_id = 6; 

FWIW:

test=# SELECT doc.id,doc.title,sub.user_id,sub.operation
test-#   FROM document doc LEFT OUTER JOIN document_subscription sub
test-#   ON sub.document_id = doc.id AND sub.user_id = 6;id | title | user_id | operation
----+-------+---------+----------- 1 | doc1  |         | 2 | doc2  |       6 | op2 4 | doc4  |         |
-- 
Dan Langille : http://www.langille.org/