Re: SQL Question: How the outer join works

[Manoj Chainani <mchainani@HOTMAIL.COM>]

So, Did that work correctly ??

Manoj


>From: Rosie ODonnell <joe.patton@NA.MARCONICOMMS.COM>
>Reply-To: SQR-USERS@list.iex.net
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>Subject: Re: SQL Question: How the outer join works
>Date: Fri, 30 Jul 1999 13:37:44 -0400
>
>I through the text together carelessly when I type in the SQL statement
>example.
>  I corrected the example statement below:
>
>
>
>
>
>
>Rosie ODonnell <joe.patton@NA.MARCONICOMMS.COM> on 07/30/99 01:20:56 PM
>
>Please respond to SQR-USERS@list.iex.net
>
>To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>cc:    (bcc: Joe Patton/LLP/RELTECCORP)
>
>Subject:  SQL Question: How the outer join works
>
>
>
>
>CSS HRizon 8.00h
>Oracle 7.3.2
>HP-UX 10.20
>SQRW 3.0.13.2
>
>I'm trying to figure out if a Reporting tool that I use(Reportsmith)
>handles
>outer joins properly, and I also need a better understanding of which side
>to
>put the (+) on when using an outer join.  Here is my situation:
>
>
>SELECT JOB.ACTION, JOB.DEPTID,  JOB.EMPLID, ACT.DESCR, PERS.NAME
>FROM
>PS_JOB JOB, PS_ACTN_REASON_TBL ACT, PS_PERSONAL_DATA PERS
>WHERE
>JOB.EFFDT BETWEEN '01-APR-98' AND '31-MAR-99'
>AND JOB.EMPL_CLASS IN ( 'A', 'E')
>AND JOB.ACTION IN ( 'TER', 'RET')
>AND JOB.EMPLID = PERS.EMPLID
>AND JOB.ACTION = ACT.ACTION
>AND JOB.ACTION_REASON = ACT.ACTION_REASON(+)
>ORDER BY
>ACT.ACTION_REASON
>
>I am referencing the ps_actn_reason_tbl just to get a description.  Some of
>the
>job records have null ACTION_REASON fields, so they won't link with the
>action/reason table.  Which side to I place the (+) on to make sure that
>the job
>records with the blank action_reason field still show up in the query
>results?
>
>Thanks,
>
>Joe Patton
>Marconi Communications


_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com