Re: Can you help with this JOIN?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Wei Weng <wweng(at)kencast(dot)com>
Cc: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Can you help with this JOIN?
Date: 2002-05-30 17:41:59
Message-ID: 1971.1022780519@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Wei Weng <wweng(at)kencast(dot)com> writes:
> But how do I write the LEFT OUTER JOIN if I don't do explicit JOINs on
> the other tables?

See the manual: there's a relevant example near the bottom of
http://www.postgresql.org/users-lounge/docs/7.2/postgres/explicit-joins.html
but you'd do well to study that whole page...

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-05-30 23:29:26 Math Huh?
Previous Message Stephan Szabo 2002-05-30 17:35:37 Re: Can you help with this JOIN?