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

On Wed, 15 Jan 2003, 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; 

yes, this query seems to give the same results as the original one.  
thanks!

best regards,
-- aspa                    http://www.kronodoc.fi/