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/
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
