Re: Self/Outer Join

From: Jill <jc_va_at_hotmail.com>
Date: Sun, 10 Oct 1999 19:51:37 -0700
Message-ID: <7tr8qv$1j0$1@bgtnsc02.worldnet.att.net>

Please replace the bad code with this. I left out a line.

SELECT

 P.NAME

,P.EMPLID
,P.ERNCD
,0 AS TST_HRS
,0. AS TST_PAY
,0. AS TST_ERN
,P.OTH_HRS AS PRD_HRS
,P.OTH_PAY AS PRD_PAY
,P.OTH_EARNS AS PRD_ERN

FROM PR_COMP P
    ,PR_COMP T
WHERE P.GLOBAL_NAME = 'PROD.WORLD'

AND T.GLOBAL_NAME = 'TEST.WORLD'            <-------------
AND P.EMPLID = T.EMPLID (+)
AND P.ERNCD = T.ERNCD   (+)
AND T.EMPLID IS NULL

Received on Sun Oct 10 1999 - 21:51:37 CDT