Re: Oracle outer join porting question

From: Marko Asplund <aspa(at)kronodoc(dot)fi>
To: Tambet Matiisen <t(dot)matiisen(at)aprote(dot)ee>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Oracle outer join porting question
Date: 2003-01-16 11:32:36
Message-ID: Pine.LNX.4.44.0301161331310.26458-100000@gamay.kronodoc.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah. 2003-01-16 12:11:49 Implementing automatic updating of primary keys...
Previous Message Ries van Twisk 2003-01-16 10:01:43 Re: RFC: A brief guide to nulls (noarchive)