Re: SQL Question: How the outer join works

[Don Mellen <donm@ONTKO.COM>]

On Fri, 30 Jul 1999, Manoj Chainani wrote:

> Hi Joe,
> Normally, it is that side of the table which may not have recs., where the
> outer join (+) is specified. i.e.

Correct, but the following...

>     AND JOB.ACTION_REASON (+) = ACT.ACTION_REASON

should be
      AND JOB.ACTION_REASON = ACT.ACTION_REASON (+)

since the job table will have a record, but the ps_actn_reason_table won't
necessarily have a record that matches.

HTH,
-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"